I wish to count the number of occurrences of specific text in a column and multiply the result by another cell. The input in the column is derived from a list. Originally I was using a countif function but now there are multiple choices within the list and I couldn’t get countif to produce the result and thought countifs would be the best solution but I’m still struggling to resolve what I thought was a simple 5 minute job.
May be:
=SUMPRODUCT(COUNTIF(C3:C31,$A$4:$A$6))*E3
Quang PT
Using your posted workbook,
try something like this:
Is that something you can work with?
Please Login or Register to view this content.
Can you describe what you are trying to accomplish a bit better? What column or cell are you trying to count? Column C? Where do you want that number to show? What number are trying to mulitply by? What is the criteria to count? Anything in your list or just 2 of them?
Please Login or Register to view this content.
Using this:
Will count the number of occurrences in C6:C22 based on text matches in the range A3:A7 (in this case, it is 6). I'm not sure what else you require, since your sample workbook seems to be disjointed.Please Login or Register to view this content.
Spread the love, add to the Rep
"None of us are as smart as all of us."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks