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.