Forum Discussion

jxboyd2's avatar
jxboyd2
Copper Contributor
Feb 10, 2022

Countif question

Good afternoon, How would you alter the formula What if you need to count certain columns/cells but they are not a running range, for example: A1, C1, E2 not A1:E2?

excel

4 Replies

    • jxboyd2's avatar
      jxboyd2
      Copper Contributor
      Feb 10, 2022
      Thank you when I did, I got the error: You've entered too few arguments for this function
      =COUNTIF(F3:I3=”No”)+COUNTIF(S3:W3=”No”)+COUNTIF(AB3=”No”)+COUNTIF(AJ3=”No”)+COUNTIF(AN3:AO3=”No”)+COUNTIF(AQ3:AR3=”No”)
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Feb 10, 2022

        jxboyd2 

        Use comma instead of equals:

         

        =COUNTIF(F3:I3,”No”)+COUNTIF(S3:W3,”No”)+COUNTIF(AB3,”No”)+COUNTIF(AJ3,”No”)+COUNTIF(AN3:AO3,”No”)+COUNTIF(AQ3:AR3,”No”)

Resources