Apr 13 2021 02:43 AM
Hello all, can some please assist in the formula to be used to count negative values in a colom.
Apr 13 2021 02:51 AM
@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.
Apr 13 2021 02:54 AM
Apr 13 2021 03:00 AM
@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.
Apr 13 2021 03:15 AM