Count number of cells matching to criteria

Solved/Closed

Rusty - Jan 16, 2009 at 02:17 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 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

Count the number of cells that meet a criterion
Google meet download for pc - Download - Video calls
Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
Youtube subscriber count - Guide
Clear only the formatting from the selected cell (leaving the content) - Guide
Excel if range of cells contains specific text then return value ✓ - Excel Forum

1 response

Answer 1 / 1

aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Jan 16, 2009 at 03:56 PM

Hello,
Try this formula :
=SUMPRODUCT((A1:A10=1)*(B1:B10="A"))
Best regards

Similar discussions

Counting cells containing only numbers

help me to add particular cells

Condition formatting on changing cell color based on another cel

how to count sentences in a paragraph..." using c language

Formula to Find&replace blank cells in excel

Similar discussions

Subscribe To Our Newsletter!