Countif formula

[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

 

[brianwa]

Try this

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

Regards,
B

 

[Nan]

Thank you! :