Adding a formula
Closed
himanshu999082
Posts
3
Registration date
Wednesday 7 August 2013
Status
Member
Last seen
8 August 2013
-
7 Aug 2013 à 02:09
Blocked Profile - 8 Aug 2013 à 12:12
Blocked Profile - 8 Aug 2013 à 12:12
Related:
- Excel add formula
- Excel add days to date - Guide
- Excel color formula - Guide
- Formula to calculate vat in excel - Guide
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- Number to words in excel formula - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
7 Aug 2013 à 03:54
7 Aug 2013 à 03:54
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!
8 Aug 2013 à 03:14
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??????