SUMIF
 

Thank you so much Tom, that was the fastest reply I have ever gotten, and it
worked like a charm.

"Tom Ogilvy" wrote:

=SUMIF(H7:H10000, "<0", H7:H10000)

or simply

=SUMIF(H7:H10000, "<0")

--
Regards,
Tom Ogilvy


"Greg Snidow" wrote:

Greetings all. I am trying to use sumif where the range and the sum range
are the same. I want to have one cell, say H1 that displays the sum of all
values in the range H7:H10000 where the value is negative. This is what I
have tried, but I get the error box saying there is something wrong with it.
Is it not possible to have range and sum range the same? And if so how else
could I do what I need to do?

=SUMIF(H7:H10000, < 0, H7:H10000)