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...
excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Jun 29, 2023

    CDNejdlRD 

    Try this:

    =SUM(COUNTIF(June!B79:CV79,{"FL","DE","IA","AR"}))
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jun 29, 2023

CDNejdlRD 

Try this:

=SUM(COUNTIF(June!B79:CV79,{"FL","DE","IA","AR"}))
CDNejdlRD's avatar
CDNejdlRD
Copper Contributor
Jun 29, 2023
Wow, that worked perfect! Thank you so much for the response