Countif question

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3150921%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ECountif%20question%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3150921%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3E%3CSPAN%3EGood%20afternoon%2C%20How%20would%20you%20alter%20the%20formula%20What%20if%20you%20need%20to%20count%20certain%20columns%2Fcells%20but%20they%20are%20not%20a%20running%20range%2C%20for%20example%3A%20A1%2C%20C1%2C%20E2%20not%20A1%3AE2%3F%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3150921%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New 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!