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.