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:
 Adding a formula
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Date formula in excel dd/mm/yyyy  Guide
 Credit summation formula  Guide
 Number to words in excel formula  Guide
 Formula bar in excel missing  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??????