Sum the excess value in a row of cell
Solved/Closed
Related:
- Based on the values in cells b77
- Based on the values in cells b77 b88 ✓ - Excel Forum
- Based on the values in cells b77 b81 what function can automatically return the value in cell c77 ✓ - Excel Forum
- Looking For a Value in a Cell - Excel Forum
- Looking up and adding the values fixing different criteria - Excel Forum
- Instagram account based in wrong country - Instagram Forum
2 responses
Ivan-hoe
Posts
433
Registration date
Saturday February 16, 2008
Status
Member
Last seen
October 17, 2008
110
Sep 12, 2008 at 05:50 AM
Sep 12, 2008 at 05:50 AM
Hello prasanna,
Let's say your values are in cells A1 to A6
The easiest way to do it is to write an intermediate formula.
Write in cells B1 =IF(A1>8;A1-8;0) and extend this formula to B6
Then write in any cell =SUM(B1:B6)
If you wish only one formula
=SUMIF(A1:A6;">8")-(COUNTIF(A1:A6;">8")*8)
Ivan
Let's say your values are in cells A1 to A6
The easiest way to do it is to write an intermediate formula.
Write in cells B1 =IF(A1>8;A1-8;0) and extend this formula to B6
Then write in any cell =SUM(B1:B6)
If you wish only one formula
=SUMIF(A1:A6;">8")-(COUNTIF(A1:A6;">8")*8)
Ivan
Sep 13, 2008 at 10:25 AM
this solves my problem
thank you very much for the tips....
regards
prasanna