Adding a formula
Closed
himanshu999082
Blocked Profile - Aug 8, 2013 at 12:12 PM
- Posts
- 3
- Registration date
- Wednesday August 7, 2013
- Status
- Member
- Last seen
- August 8, 2013
Blocked Profile - Aug 8, 2013 at 12:12 PM
Related:
- 1st, 2nd, 3rd position formula in excel
- Excel formula for adding vat - Guide
- Excel adding apostrophe before formula - Guide
- Spreadsheet formula - Articles
- Excel @ in formula ✓ - Forum - Excel
- Little alchemy formulas - Guide
2 replies
venkat1926
Aug 7, 2013 at 03:54 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Aug 7, 2013 at 03:54 AM
not clear to me. give one or two examples with cell addresses and vlues. alernatively post a very small extract and explain
TO FOLLOW THIS EXAMPLE, you must understand the following:
GIVEN:
All descriptions wrapped in { } are formulas contained within the cell called out, so the eample of {b7[=sum(b2:b6)]} is the formula that needs to be entered into b7 =sum(b2:b6) and drop the "[" & "]"!
If you do not understand this above explaination, than none of it matters.
1 2 3 4 5 6 7
ROWA - article # 36 38 40 42 44 total
ROW B- SUCD 601 2 0 2 1 0 5 {b7[=sum(b2:b6)]}
ROW C- SUCI 1054 0 1 0 0 0 1 {C7[=SUM(C2:C6)]}
ROW D- SUEI 176 0 0 0 1 0 1 {d7[=sum(d2:d6)]}
-----------------------------------
ROW E- 7 {e7[=sum(b7:d7)]}
If this is not what you expected, then please reword your example, as I am fairly certain this is what you are asking!
Have Fun!
GIVEN:
All descriptions wrapped in { } are formulas contained within the cell called out, so the eample of {b7[=sum(b2:b6)]} is the formula that needs to be entered into b7 =sum(b2:b6) and drop the "[" & "]"!
If you do not understand this above explaination, than none of it matters.
1 2 3 4 5 6 7
ROWA - article # 36 38 40 42 44 total
ROW B- SUCD 601 2 0 2 1 0 5 {b7[=sum(b2:b6)]}
ROW C- SUCI 1054 0 1 0 0 0 1 {C7[=SUM(C2:C6)]}
ROW D- SUEI 176 0 0 0 1 0 1 {d7[=sum(d2:d6)]}
-----------------------------------
ROW E- 7 {e7[=sum(b7:d7)]}
If this is not what you expected, then please reword your example, as I am fairly certain this is what you are asking!
Have Fun!
Aug 8, 2013 at 03:14 AM
36 38 40 42 44 TOTAL
SUCD 601 2 0 2 1 0 5
SUCI 1054 0 1 0 0 0 1
SUEI 176 0 0 0 1 0 1
now if ihave to add my sale, so that it would be auto deduct from the total, then how is it possible??????