Hello,

I have a need for a formula that will do as follows.

I have a spread sheet that is filled in every hour with different
totals.

I need to know how to make what ever total show for the next hour to be
put in specified cell. There may be a amount or maybe nothing.

Example:

Hour 1

I need to know the amount for every hour in D43:k43 with G5 being where
the answer needs to go.

D43 $100.00 nothing in the rest Total Cell G5 $100.00

Hour 2

D43 $100.00 E43 0 Total Cell G5 0

Hour 3

D43 $100.00 E43 0 F43 $85.00 Total Cell G5 $85.00

Hour 4

D43 $100.00 E43 0 F43 $85.00 G43 $102.00 Total Cell
G5 $102.00

Hour 5

D43 $100.00 E43 0 F43 $85.00 G43 $102.00 H43 $15.00


Total Cell G5 $15.00

Hour 6

D43 $100.00 E43 0 F43 $85.00 G43 $102.00 H43 $15.00
I43 $352.00

Total Cell G5 $352.00

and so on for the Final Letters to K43

Can someone Help

Thanks flapokey ;)


--
flapokey
------------------------------------------------------------------------
flapokey's Profile: http://www.excelforum.com/member.php...o&userid=26690
View this thread: http://www.excelforum.com/showthread...hreadid=400503