Forum Discussion

CDNejdlRD's avatar
CDNejdlRD
Copper Contributor
Jun 29, 2023
Solved

Count IF

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?

Resources