Negative numbers

[Kolsballs]

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.

 

[Teethless mama]

Maybe your data is format as text instead of general.

 

[T. Valko]

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

There's nothing wrong with your formula so that means there's a problem with
your data (provided there are in fact -ve numbers present). Common causes:

numbers formatted as TEXT
leading/trailing spaces or other unseen characters

 

[Héctor Miguel]

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")

if your "number" are stored as text... try with something like:

=sumproduct((--sheet1!b3:h23<0)*(--sheet1!b3:h23))

hth,
hector.

 

[Kolsballs]

Maybe your data is format as text instead of general.

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