ExcelBanter - Creating a Count formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Creating a Count formula (https://www.excelbanter.com/excel-worksheet-functions/91356-creating-count-formula.html)

Shelyna

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?

Bob Phillips

Creating a Count formula

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Shelyna" wrote in message
...
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?

All times are GMT +1. The time now is 03:24 AM.