Assistance in formula to count conditionally formatted coloms

[Sanet1510]

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

[#2]

@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. 

[#3]

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

[#4]

@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.

[#5]

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