Creating a Count formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CountIf previous cell formula 0
Counting Results of Formulas 1
Warning when in another cell after entering a formula. 2
Excel Need Countifs Formula Help 0
countifs Function not giving desired result with date criteria 2
CountIf question 2
Excel Formula - Count Dates from another Sheet 8
Counting Multiple Records by specific criteria 5

Back
Top