"Teethless mama" wrote:

Maybe your data is format as text instead of general.


"Kolsballs" wrote:

Hi

I am trying to add only the negative numbers in a row of cells from sheet 1
and have the results shown in a single cell on sheet 3, but I keep only
getting the result of zero how would I correct this. The formula I am using
in the cell on sheet three is:

=SUMIF(Sheet1!B23:H23,"<0")

Any help appreciated.

Hi Thanks for the help. Got it to work eventually.