Microsoft Office Forums - View Single Post - Sum required without consider the negative amount

Thread: Sum required without consider the negative amount

View Single Post

Old

08-22-2011, 02:16 AM

OTPM

OTPM is offline

OTPM uses Windows 7 32bit

Windows 7 32bit OTPM uses Office 2010 32bit

OTPM uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Apr 2011

Location: West Midlands

Posts: 981

OTPM is on a distinguished road

Default

Hi Pradeep
Use this formula:

=SUMIF(B3:E3,">0")

Kind regards
Tony(OTPM)

Reply With Quote