Creating a Count formula

S

Shelyna

Current formula is: =COUNTIF(M8:M145,"WV")

From that info, I want to count the data from another column (X) that
coincides with the "WV" data that I just collected.
X column contains an IF formula: =IF((C145>$a$1),0,1) ... [from cell 8:145]

What would my formula be?
 
B

Bob Phillips

=SUMIF(M8:M145,"WV",X8:X145)


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top