Thread: What formula/fn would I use to count multiple condition records?
View Single Post
  #3   Report Post  
CLR
 
Posts: n/a
Default What formula/fn would I use to count multiple condition records?
=COUNTIF(A:A,"=7")+COUNTIF(B:B,"<7")+COUNTIF(C:C, "=7")

Vaya con Dios,
Chuck, CABGx3


"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.


Reply With QuoteReply With Quote