Forum Discussion
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?
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”)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!
