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.

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.

=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

--
Biff
Microsoft Excel MVP


"Kolsballs" wrote in message
...
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, !

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.

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