Hi Folks,
Need some help with a Countifs on excel.
I want to count the number of quantity of each size of product the specific sales persons have sold.
At the moment I have only gone as far as counting how many Smalls, Mediums, Larges each sales person has sold using the =COUNTIFS(D:D,"Large",F:F,"Alex") But have not been able to add the quantity of each product- would really appreciate some help?
I have attached a sample working data
Sounds like you want SUMIFS:
=SUMIFS(E:E,D:D,"Large",F:F,"Alex")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Simply use Sumifs if you are looking for adding qty as you did for counting.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks