Countif question

Copper Contributor

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?

4 Replies

@jxboyd2 

Add the separate counts together.

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”)

@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”)

Thank you sooooo much!