Adding a formula
Closed
himanshu999082
Posts
3
Registration date
Wednesday August 7, 2013
Status
Member
Last seen
August 8, 2013
-
Aug 7, 2013 at 02:09 AM
Blocked Profile - Aug 8, 2013 at 12:12 PM
Blocked Profile - Aug 8, 2013 at 12:12 PM
Related:
- Excel add formula
- Number to words in excel formula - Guide
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- Percentage formula in excel marksheet - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Add gif to excel - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 7, 2013 at 03:54 AM
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??????