Count matching cells

  • Thread starter Thread starter The Mage
  • Start date Start date
T

The Mage

I have 2 columns of 30 numbers, side by side. All numbers are 1 to 6.
I need to count every time the numbers in a row both equal 2, 3, 4, or
5. (Matching pairs.)

I cannot think of how to do this without using 30 if functions for each
number, and summing the count. To clarify I need to count total
matching 2’s, then total matching 3’s, etc.

Thanks for any assistance.
 
Hi,

You may also use an array formula (Ctrl+Shift+Enter) to accomplish the same.

=sum(if((range=2),1,0)
=sum(if((range=3),1,0) etc.

Regards,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count if matching text 6
Match and delete rows on two different sheets from reference numbers 4
complex sort search and replace macro 2
Function to Use when compare sums another column 3
Counting formula 1
Conditional Counting of Duplicated Names 4
Match 2 Columns, Return 3rd, Differing Match Types 3
Counting Matched Values 3

Back
Top