| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Create a running totaol
CELL A1 has a number CELL B1 is the total (A1). As I add a number in CELL A2 I want CELL B2 to be the running total. Then I add a number to CELL A3 and I want B3 to be the total and etc. I don't want the cells in B to have any number in them untill I add something in column A. Please help. THANKS!! -- Jdog ------------------------------------------------------------------------ Jdog's Profile: http://www.excelforum.com/member.php...o&userid=28433 View this thread: http://www.excelforum.com/showthread...hreadid=480321 |
|
#3
|
|||
|
|||
|
Create a running totaol
Try this for a non-volatile suggestion:
=IF(A1,SUM($A$1:A1),"") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Jdog" wrote in message ... CELL A1 has a number CELL B1 is the total (A1). As I add a number in CELL A2 I want CELL B2 to be the running total. Then I add a number to CELL A3 and I want B3 to be the total and etc. I don't want the cells in B to have any number in them untill I add something in column A. Please help. THANKS!! -- Jdog ------------------------------------------------------------------------ Jdog's Profile: http://www.excelforum.com/member.php...o&userid=28433 View this thread: http://www.excelforum.com/showthread...hreadid=480321 |
|
#4
|
|||
|
|||
|
Create a running totaol
"RagDyeR" wrote in message
... Try this for a non-volatile suggestion: =IF(A1,SUM($A$1:A1),"") I assume that you mean to copy the formula down or you meant =IF(A1,SUM(A:A),"") which would be fine if there was no other numbers in column A. If you meant copy down and the OP had say, 4,000 rows of data, would that not be more of a calculation load than a volatile function? Of course it would depend on what the rest of the sheet was like. -- Regards Sandy Replace@mailinator with @tiscali.co.uk |
|
#5
|
|||
|
|||
|
Create a running totaol
Meant to copy down. Look again
$a$1:a1 -- Don Guillett SalesAid Software "Sandy Mann" wrote in message ... "RagDyeR" wrote in message ... Try this for a non-volatile suggestion: =IF(A1,SUM($A$1:A1),"") I assume that you mean to copy the formula down or you meant =IF(A1,SUM(A:A),"") which would be fine if there was no other numbers in column A. If you meant copy down and the OP had say, 4,000 rows of data, would that not be more of a calculation load than a volatile function? Of course it would depend on what the rest of the sheet was like. -- Regards Sandy Replace@mailinator with @tiscali.co.uk |
|
#6
|
|||
|
|||
|
Create a running totaol
Thank you Don.
You can be my lawyer any time you wish!<bg -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Don Guillett" wrote in message ... Meant to copy down. Look again $a$1:a1 -- Don Guillett SalesAid Software "Sandy Mann" wrote in message ... "RagDyeR" wrote in message ... Try this for a non-volatile suggestion: =IF(A1,SUM($A$1:A1),"") I assume that you mean to copy the formula down or you meant =IF(A1,SUM(A:A),"") which would be fine if there was no other numbers in column A. If you meant copy down and the OP had say, 4,000 rows of data, would that not be more of a calculation load than a volatile function? Of course it would depend on what the rest of the sheet was like. -- Regards Sandy Replace@mailinator with @tiscali.co.uk |
|
#7
|
|||
|
|||
|
Create a running totaol
OK. One billable second. If I was a lawyer I would have to charge for an
hour. -- Don Guillett SalesAid Software "RagDyeR" wrote in message ... Thank you Don. You can be my lawyer any time you wish!<bg -- Regards, RD -------------------------------------------------------------------------- -- ------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------------- -- ------------------- "Don Guillett" wrote in message ... Meant to copy down. Look again $a$1:a1 -- Don Guillett SalesAid Software "Sandy Mann" wrote in message ... "RagDyeR" wrote in message ... Try this for a non-volatile suggestion: =IF(A1,SUM($A$1:A1),"") I assume that you mean to copy the formula down or you meant =IF(A1,SUM(A:A),"") which would be fine if there was no other numbers in column A. If you meant copy down and the OP had say, 4,000 rows of data, would that not be more of a calculation load than a volatile function? Of course it would depend on what the rest of the sheet was like. -- Regards Sandy Replace@mailinator with @tiscali.co.uk |
|
#8
|
|||
|
|||
|
Create a running totaol
Don Guillett" wrote in message
... Meant to copy down. Look again $a$1:a1 So it does. My apologies to RagDyeR -- Sandy Replace@mailinator with @tiscali.co.uk "Don Guillett" wrote in message ... Meant to copy down. Look again $a$1:a1 -- Don Guillett SalesAid Software "Sandy Mann" wrote in message ... "RagDyeR" wrote in message ... Try this for a non-volatile suggestion: =IF(A1,SUM($A$1:A1),"") I assume that you mean to copy the formula down or you meant =IF(A1,SUM(A:A),"") which would be fine if there was no other numbers in column A. If you meant copy down and the OP had say, 4,000 rows of data, would that not be more of a calculation load than a volatile function? Of course it would depend on what the rest of the sheet was like. -- Regards Sandy Replace@mailinator with @tiscali.co.uk |
|
#9
|
|||
|
|||
|
Create a running totaol
"Sandy Mann" wrote in message
... Don Guillett" wrote in message ... Meant to copy down. Look again $a$1:a1 So it does. My apologies to RagDyeR Or should I say my apologies to your client <g -- Sandy Replace@mailinator with @tiscali.co.uk "Sandy Mann" wrote in message ... Don Guillett" wrote in message ... Meant to copy down. Look again $a$1:a1 So it does. My apologies to RagDyeR -- Sandy Replace@mailinator with @tiscali.co.uk "Don Guillett" wrote in message ... Meant to copy down. Look again $a$1:a1 -- Don Guillett SalesAid Software "Sandy Mann" wrote in message ... "RagDyeR" wrote in message ... Try this for a non-volatile suggestion: =IF(A1,SUM($A$1:A1),"") I assume that you mean to copy the formula down or you meant =IF(A1,SUM(A:A),"") which would be fine if there was no other numbers in column A. If you meant copy down and the OP had say, 4,000 rows of data, would that not be more of a calculation load than a volatile function? Of course it would depend on what the rest of the sheet was like. -- Regards Sandy Replace@mailinator with @tiscali.co.uk |
|
#10
|
|||
|
|||
|
Create a running totaol
It would have to be copied down in order to fulfill the OP's request of
being a *running* total. And, of course ... I always follow OP directives.<g As far as volatility ... 4,000 rows being calculated every time *anything* in the sheet changes, is really not even a point of discussion. -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Sandy Mann" wrote in message ... "RagDyeR" wrote in message ... Try this for a non-volatile suggestion: =IF(A1,SUM($A$1:A1),"") I assume that you mean to copy the formula down or you meant =IF(A1,SUM(A:A),"") which would be fine if there was no other numbers in column A. If you meant copy down and the OP had say, 4,000 rows of data, would that not be more of a calculation load than a volatile function? Of course it would depend on what the rest of the sheet was like. -- Regards Sandy Replace@mailinator with @tiscali.co.uk |
|
#11
|
|||
|
|||
|
Create a running totaol
The problem I have with this solution is that if you work with the
results of the running total you get #value because of the "" value. Sandy Mann wrote: "RagDyeR" wrote in message ... Try this for a non-volatile suggestion: =IF(A1,SUM($A$1:A1),"") I assume that you mean to copy the formula down or you meant =IF(A1,SUM(A:A),"") which would be fine if there was no other numbers in column A. If you meant copy down and the OP had say, 4,000 rows of data, would that not be more of a calculation load than a volatile function? Of course it would depend on what the rest of the sheet was like. |
|
#12
|
|||
|
|||
|
Create a running totaol
The OP asked that "no number" be present until a value was entered in Column
A. What are your specs? Can you accept a zero? =IF(A1,SUM($A$1:A1),0) Also, exactly what formula are you using, and in what way are you using it, that's giving you an error? There might be viable "workarounds". -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "noyb" wrote in message ... The problem I have with this solution is that if you work with the results of the running total you get #value because of the "" value. Sandy Mann wrote: "RagDyeR" wrote in message ... Try this for a non-volatile suggestion: =IF(A1,SUM($A$1:A1),"") I assume that you mean to copy the formula down or you meant =IF(A1,SUM(A:A),"") which would be fine if there was no other numbers in column A. If you meant copy down and the OP had say, 4,000 rows of data, would that not be more of a calculation load than a volatile function? Of course it would depend on what the rest of the sheet was like. |
|
#13
|
|||
|
|||
|
Create a running totaol
My apologies, I was actually reacting generally to the fact that Excel
does not handle the results of a formula which resolves to "" very well and not to this specific question. Ragdyer wrote: The OP asked that "no number" be present until a value was entered in Column A. What are your specs? Can you accept a zero? =IF(A1,SUM($A$1:A1),0) Also, exactly what formula are you using, and in what way are you using it, that's giving you an error? There might be viable "workarounds". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i create a running total in Excel? | Excel Discussion (Misc queries) | |||
| how do i create a running balance on checkbook register | Excel Discussion (Misc queries) | |||
| Template in Excel | New Users to Excel | |||
| Pivot table (Running Averages) | Excel Worksheet Functions | |||
| How do I create a running report on Excel | New Users to Excel | |||
Hybrid Mode
