Feb 10 2022 10:31 AM
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?
Feb 10 2022 11:34 AM
Feb 10 2022 11:42 AM - edited Feb 10 2022 11:42 AM
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”)