Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-22-2011, 01:31 AM
PRADEEPB270's Avatar
PRADEEPB270 PRADEEPB270 is offline Sum required without consider the negative amount Windows Vista Sum required without consider the negative amount Office 2007
Novice
Sum required without consider the negative amount
 
Join Date: Aug 2011
Location: Gurgaon-INDIA
Posts: 17
PRADEEPB270 is on a distinguished road
Default Sum required without consider the negative amount


I want to sum the row total without cosider the negative amount.For more clarificatio ,please see the attached file.

Regards

Pradeep
Attached Files
File Type: xlsx Book1.xlsx (9.3 KB, 12 views)
Reply With Quote
  #2  
Old 08-22-2011, 02:16 AM
OTPM OTPM is offline Sum required without consider the negative amount Windows 7 32bit Sum required without consider the negative amount 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
  #3  
Old 08-22-2011, 04:23 AM
PRADEEPB270's Avatar
PRADEEPB270 PRADEEPB270 is offline Sum required without consider the negative amount Windows Vista Sum required without consider the negative amount Office 2007
Novice
Sum required without consider the negative amount
 
Join Date: Aug 2011
Location: Gurgaon-INDIA
Posts: 17
PRADEEPB270 is on a distinguished road
Default

Thanks a lot sir.

Regards
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Start slides from a negative number powerpointbry PowerPoint 12 06-29-2011 12:14 AM
automatic quantity updation of total amount is restricted. aligahk06 Excel 0 05-23-2010 08:39 AM
Analysis of Amount based on following criterion. aligahk06 Excel 1 04-24-2010 10:34 AM
Convert Dollar amount to text GeorgeLawshe Word 0 03-07-2010 10:17 PM
Is there a way to change the header in a large amount of documents at one time? ntsstaffing Word 1 07-11-2009 12:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft