Count IF

[CDNejdlRD]

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 · Accepted solution]

@CDNejdlRD 

Try this:

=SUM(COUNTIF(June!B79:CV79,{"FL","DE","IA","AR"}))

[#3]

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