What formula/fn would I use to count multiple condition records?
"Joshcat99" wrote in message
...
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.
Hope this works:
=SUMPRODUCT(--(A281:A288=7),--(B281:B288<7),--(C281:C288=7))
Ciao
Bruno
|