Forum Discussion

Tullyk's avatar
Tullyk
Copper Contributor
Feb 21, 2019

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 use this formula or anyother formula to add the "F" and the "FF" in the same rage to get an answer of 2 please see attached images to help show what i mean. 

excel

2 Replies

  • Ed Hansberry's avatar
    Ed Hansberry
    Iron Contributor
    Feb 21, 2019

    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")

Resources