Forum Discussion

Sanet1510's avatar
Sanet1510
Copper Contributor
Apr 13, 2021

Assistance in formula to count conditionally formatted coloms

Hello all, can some please assist in the formula to be used to count negative values in a colom.  
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 13, 2021

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. 

  • Sanet1510's avatar
    Sanet1510
    Copper Contributor
    Apr 13, 2021
    @riny_I have done that but it keeps on saying that something is wrong with my formula
    • Sanet1510's avatar
      Sanet1510
      Copper Contributor
      Apr 13, 2021
      I got it to work! Thanks...there were hidden rows
    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Apr 13, 2021

      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.

       

Resources