Forum Discussion

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...

excel

Formulas and Functions

Detlef_Lewin
Jun 29, 2023
CDNejdlRD
Try this:
=SUM(COUNTIF(June!B79:CV79,{"FL","DE","IA","AR"}))

Detlef_Lewin

Silver Contributor

Jun 29, 2023

CDNejdlRD

Try this:

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

CDNejdlRD
Copper Contributor
Jun 29, 2023
Wow, that worked perfect! Thank you so much for the response