Count number of cells matching to criteria [Solved/Closed]

Report
-
Posts
7081
Registration date
Saturday April 7, 2007
Status
Anonymous
Last seen
September 25, 2020
-
Hello,

I have two column lists (one value in each cell) the first { 1 2 3 1 2 2 2 1 1 1 } and the second {A B C C C B B A A C } and I am attempting to find out how to auto count two criteria such as... if the first column is 1 and the second column is A then count. i.e for this example the answer would be..3.

Help?
Thanks

1 reply

Posts
7081
Registration date
Saturday April 7, 2007
Status
Anonymous
Last seen
September 25, 2020
498
Hello,
Try this formula :
=SUMPRODUCT((A1:A10=1)*(B1:B10="A"))
Best regards
18
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month