Shorter version

=SUMIF(A1:A11,"<0")


Gord

On Tue, 08 Sep 2009 08:44:39 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

=SUMIF(A1:A11,"<0",A1:A11)


Gord Dibben MS Excel MVP

On Tue, 8 Sep 2009 05:36:01 -0700, lalitmishra
wrote:



"Melissa" wrote:

To give a simple example, I would like to sum a range of cells only if the
values are not 0. So the sum should include both positive and negative
numbers. What would the formula look like?
Thank you very much.plz halp mee to you than any thing question to serial answwer