Count function help
Hello,
May I seek help about count function.
I would want to count the number of colors collected by a given person. I just dont know the formula to get it. :'(
I have attached the sample data to make it easier.
I was trying to work on the Summary tab. The search criteria is in the Raw tab.
Please help.
Thank you in advance
A pivot table will do this for you.
See the attached
<----if this helped you please click the star.
http://excelevangelist.blogspot.com/
The pivot table approach may be easiest, but if you must have a formula...
Using your posted workbook, this regular formula begins the count of name/color combinations
Copy that formula across and down through G13.
Please Login or Register to view this content.
Does that help?
you could also use something like this
Add the following forumula to cell C4 in your summary sheet.
Then copy it to the rest of the summary table.
=SUMPRODUCT((Raw!$B$2:$B$27=$B4)*(Raw!C$2:C$27=1))
I have updated the previous spreadsheet to include this
See attached
Thank you!!!Originally Posted by Ron Coderre
The pivot table approach may be easiest, but if you must have a formula...
Using your posted workbook, this regular formula begins the count of name/color combinations
Copy that formula across and down through G13.Please Login or Register to view this content.
Does that help?
That does it
Thank you too Mark. Very much appreciated guys
C4 cell =SUMIF(Raw!$B$2:$B$27,Summary!$B4,INDEX(Raw!$C$2:$G$27,,MATCH(Summary!C$3,Raw!$C$1:$G$1,0)))
Just an another approach
Appreciate the help? CLICK *
Editing...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks