Forum Discussion
COUNTIF HELP
Hi, i posted earlier re staff going to fires, i have since been told to use the COUNTIF formula. this works great if i just want to count the "F" in my range but i was wondering if there is a way to ...
You can use wild cards if that helps.
=COUNTIFS(B2:E2,"F*")
But if wild cards won't work, for example, you need to count the F and T cells, you could use 2 formulas:
=COUNTIFS(B2:E2,"F")+COUNTIFS(B2:E2,"T")
Or
=SUM(COUNTIF(B2:E2,{"F","T"}))
