View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shelyna
 
Posts: n/a
Default 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?