Assistance in formula to count conditionally formatted coloms

%3CLINGO-SUB%20id%3D%22lingo-sub-2269746%22%20slang%3D%22en-US%22%3EAssistance%20in%20formula%20to%20count%20conditionally%20formatted%20coloms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2269746%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%20can%20some%20please%20assist%20in%20the%20formula%20to%20be%20used%20to%20count%20negative%20values%20in%20a%20colom.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2269746%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello all, can some please assist in the formula to be used to count negative values in a colom.

 

4 Replies

@Sanet1510 Try this: 

=COUNTIF(A1:A50,"<0")

where A1:A50 contains the values that you want to test. Changes this range to your own needs. 

@riny_I have done that but it keeps on saying that something is wrong with my formula

@Sanet1510 Please elaborate. Are the numbers really numbers or are they perhaps texts looking like numbers. Have a look at the attached file. Perhaps you need a semi-colon in stead of a comma between the formula arguments.

 

I got it to work! Thanks...there were hidden rows