What formula/fn would I use to count multiple condition records?

J

Joshcat99

I need a formula/function that would work to count the number of records that
have >=7 in the 1st column, <7 in the 2nd column and >=7 in the 3rd column.
 
B

Bruno Campanini

Joshcat99 said:
I need a formula/function that would work to count the number of records
that
have >=7 in the 1st column, <7 in the 2nd column and >=7 in the 3rd
column.
Click to expand...

Hope this works:
=SUMPRODUCT(--(A281:A288>=7),--(B281:B288<7),--(C281:C288>=7))

Ciao
Bruno
 
C

CLR

=COUNTIF(A:A,">=7")+COUNTIF(B:B,"<7")+COUNTIF(C:C,">=7")

Vaya con Dios,
Chuck, CABGx3


Joshcat99 said:
I need a formula/function that would work to count the number of records that
have >=7 in the 1st column, <7 in the 2nd column and >=7 in the 3rd
Click to expand...
column.
 
A

Ashish Mathur

Hi,

You may use the sumif array formula as well (Ctrl+Shift+Enter)

=sum(if((range>=7)*(range2<7)*(range3>=7),1,0))

Regards,

Ashish Mathur
 
Top