Using COUNTIF to count 3 colums of information

A

AnnaV

I would like to count specific criteria in 4 seperate colums. I can us
the formula if I am counting one column, but I'm not sure how to ente
the other 3 columns.

The formula I use to count section 1 is =COUNTIF($B$2:$B$62,">4")

That works for one column, but how do I include columns H, N, and T i
the same formula
 
R

RagDyer

You can try this:

=SUMPRODUCT((B2:B52>4)+(H2:H52>4)+(N2:N52>4)+(T2:T52>4))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I would like to count specific criteria in 4 seperate colums. I can use
the formula if I am counting one column, but I'm not sure how to enter
the other 3 columns.

The formula I use to count section 1 is =COUNTIF($B$2:$B$62,">4")

That works for one column, but how do I include columns H, N, and T in
the same formula?
 
D

Domenic

AnnaV said:
I would like to count specific criteria in 4 seperate colums. I can use
the formula if I am counting one column, but I'm not sure how to enter
the other 3 columns.

The formula I use to count section 1 is =COUNTIF($B$2:$B$62,">4")

That works for one column, but how do I include columns H, N, and T in
the same formula?
Click to expand...

Hi Anna,

If you're trying to count the number of times a value appears in all
four columns, try:

=SUMPRODUCT((B2:B4>4)+(H2:H4>4)+(N2:N4>4)+(T2:T4>4))

Hope this helps!
 
Top