#1
|
||||
|
||||
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 |
#2
|
|||
|
|||
Hi Pradeep
Use this formula: =SUMIF(B3:E3,">0") Kind regards Tony(OTPM) |
#3
|
||||
|
||||
Thanks a lot sir.
Regards |
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 |