Sum the excess value in a row of cell
Solved/Closed
Related:
- Based on the values in cells b77
- Excel macro to create new sheet based on value in cells - Guide
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Insert picture in Excel macro which takes the file name refrence - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
- How would you change all cells containing the word pass to green - Excel 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