Countif formula

  • Thread starter Thread starter Nan
  • Start date Start date
N

Nan

I have a column (F3:F142) that contains various text in each cell (o
the cell may also be blank). I would like to be able to total th
number of cells that contain either DWS or WL. Can anyone please help?
Thanks
 
Try this

=(COUNTIF(f3:f142,"dws"))+(COUNTIF(f3:f142,"wl"))

Regards,
B
 
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

SUMIF with criteria "<>" & "=" 4
Excel Need Countifs Formula Help 0
Excel Use COUNTIF across a range of cells with formulas 0
CountIf previous cell formula 0
Countifs 2
Excel Countif cell has diagonal border 6
Conditional Formatting with COUNTIF 2
filtering data within data 9

Back
Top