Creating a Count formula

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?

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


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Shelyna" <Shelyna@discussions.microsoft.com> wrote in message
news:748F9D57-46DD-4E6B-A429-8678EE5B8643@microsoft.com...
> 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?
>
>
>
>
>