Previous Topic Next Topic

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
Hello,

how do i may be able to get auto deduct formula from a sum method of multi cells ?

Thanks

2 replies

Answer 1 / 2
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
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
0
himanshu999082 Posts 3 Registration date Wednesday August 7, 2013 Status Member Last seen August 8, 2013
Aug 8, 2013 at 03:14 AM
Article no. SIZE
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??????
0
Answer 2 / 2
Blocked Profile
Aug 8, 2013 at 12:12 PM
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!
0