Count IF

Copper Contributor

I have a row of data and would like to count the number of times 4 different criteria appear in that same row.  

I can get it to do one- =COUNTIF(June!B79:CV79,"FL")

which finds the number of times FL appears. 

I also need to count 3 other states DE, IA, AR within that same range. Is this possible in one formula?

2 Replies
best response confirmed by CDNejdlRD (Copper Contributor)


Try this:

Wow, that worked perfect! Thank you so much for the response