http://chandoo.org/forums/topic/sum-sub-total Ask Excel and Charting Questions, Muse about Visualizations, Learn and Share - Discussion Forums - Chandoo.org en-US Mon, 20 May 2013 00:41:13 +0000 http://bbpress.org/?v=1.0.1 q http://chandoo.org/forums/search.php http://chandoo.org/forums/topic/sum-sub-total#post-15551 Mon, 19 Dec 2011 02:18:10 +0000 rbobcat1 15551@http://chandoo.org/forums/ <p>yes but maybe i explained it wrong; i realize this is a little different than my first post but i was playing with what you posted to see if i could make it work.<br /> i want to use column b as an input area. i am counting money and want to keep a running total of the quantity of the denomination and what the total value is. in the case below i have 49 1$ bills. but if i add 10 to the 49 total i have 59 1$ bills. the problem is whan i change b2 it changes it across the row to that amount and is not keeping a count of the qty of 1$ and to total $ amount.<br /> a b c d e<br /> money QTY INPUT qty qty-tot total<br /> $1.00 49 49 49 $49.00<br /> $5.00 19 95 $95.00<br /> $10.00 8 80 $80.00<br /> $20.00 4 80 $80.00<br /> $50.00 0 0 $0.00 </p> http://chandoo.org/forums/topic/sum-sub-total#post-15540 Sun, 18 Dec 2011 09:27:15 +0000 Hui 15540@http://chandoo.org/forums/ <p>Shouldn't your cells be as follows</p> <p>C2: =A2*B2<br /> D2: =C2<br /> Copy C2: Down</p> <p>D3: =D2+C3<br /> Copy D3: Down </p> http://chandoo.org/forums/topic/sum-sub-total#post-15531 Sun, 18 Dec 2011 02:57:29 +0000 rbobcat1 15531@http://chandoo.org/forums/ <p>Having an issue with sum and subtotal or not sure if i should be using either;<br /> a b c d<br /> 1 Cost qty sub-total total<br /> 2 1.00 1 15 15.00</p> <p>the problem is when i change b1 it also changes c2 and d2 to whatever number i put.</p> <p>i need it to add the qty to c2 then add the amount to d2</p> <p>So if i put 5 in b2, c2 should change to 20 and d2 should change to 20.00 </p>