I ENTERED THE FORMULA THAT YOU SUGGESTED AS OPPOSED TO THE SIMPLIFIED ONE I
HAD USED PREVIOUSLY---- AND PROMPTLY ENDED UP WITH THE SAME RESULT. IN OTHER
WORDS, AS SOON AS I COPIED THE FORMULA DOWN THE COLUMN FOR ABOUT TEN MORE
ROWS THE SAME AMOUNT APPEARED OVER AND OVER AGAIN ALL THE WAY DOWN.

ALSO, YOUR FORMULA CREATED ANOTHER PROBLEM. THE RUNNING TOTAL (WHICH WAS
"CURRENCY" WITH "2" DECIMAL PLACES) WOULD BE 1 CENT OFF ABOUT EVERY OTHER
RUNNING TOTAL. ANY FURTHER SUGGESTIONS TO RESOLVE THESE NOW TWO PROBLEMS?
(MY CAPS LOCK KEY IS STUCK ON). THANKS FOR TRYING TO
HELP!!!!!!!!!!!!!!!!!!!!

"Desert Piranha" wrote:


LOST IN EXCEL 2000 Wrote:
RETAIL VALUE IN COLUMN A1; SALES TAX IN COLUMN B1; SUBTOTAL IN COLUMN
C1; AND
RUNNING TOTAL IN COLUMN D1.
RETAIL VALUE IN COLUMN A2; SALES TAX IN COLUMN B2; SUBTOTAL IN COLUMN
C2;
AND RUNNING TOTAL FORMULA IN COLUMN D2 WHICH SAYS:
=SUM(D1,C2). THIS GIVES ME THE CORRECT ANSWER IN COLUMN D2. HOWEVER,
WHEN
I COPY THE FORMULA DOWN THE ROWS IN COLUMN D THE SAME AMOUNT REPEATS
ITSELF
OVER AND OVER AGAIN IN EVERY ROW. IN OTHER WORDS THE SAME RUNNING
TOTAL THAT
I GOT IN D2 ENDS UP GOING INTO D3,D4,D5,D6, ETC. I DON'T WANT THE
CALCULATED RUNNING TOTAL TO SHOW IN D3 UNTIL I HAVE ENTERED THE
SUBTOTAL IN
C3. HOW DO I PREVENT THE RUNNING TOTAL FROM APPEARING OVER AND OVER
AGAIN
UNTIL I HAVE ENTERED THE SUBTOTAL?????????????????Hi Lost,
Please don't type in all upper case.

Try this in D2 and copy down, as far as you need.
=IF(C2="","",(SUM(D1,C2)))


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=496002