Count number of cells matching to criteria
Solved/Closed
Rusty
-
Jan 16, 2009 at 02:17 PM
aquarelle Posts 7180 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - Jan 16, 2009 at 03:56 PM
aquarelle Posts 7180 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - Jan 16, 2009 at 03:56 PM
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
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:
- Count the number of cells that meet a criterion
- Google meet download for pc - Download - Video calls
- Google meet camera not working - Guide
- Count number of occurrences in excel - Guide
- How to count names in excel - Guide
- Google meet extension - Guide
1 response
aquarelle
Posts
7180
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
491
Jan 16, 2009 at 03:56 PM
Jan 16, 2009 at 03:56 PM
Hello,
Try this formula :
=SUMPRODUCT((A1:A10=1)*(B1:B10="A"))
Best regards
Try this formula :
=SUMPRODUCT((A1:A10=1)*(B1:B10="A"))
Best regards
