Previous Topic Next Topic

Count number of cells matching to criteria

Solved/Closed
Rusty - 16 Jan 2009 à 14:17
aquarelle Posts 7181 Registration date Saturday 7 April 2007 Status Moderator Last seen 14 February 2026 - 16 Jan 2009 à 15:56
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
Related:

1 response

Réponse 1 / 1
aquarelle Posts 7181 Registration date Saturday 7 April 2007 Status Moderator Last seen 14 February 2026 491
16 Jan 2009 à 15:56
Hello,
Try this formula :
=SUMPRODUCT((A1:A10=1)*(B1:B10="A"))
Best regards

Similar discussions

Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to count the number of occurrences in a range
STUDENTFJR -
Mazzaropi -

3 responses