Formula Help PLEASE !!!!

[flapokey]

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

 

[Bob Phillips]

=INDEX(D43:K43,,MAX(IF(D43:K43<>"",COLUMN(D43:K43)))-COLUMN(D43)+1)

as an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[flapokey]

Hello,

Thank you for your help, but the fomula did not work. I did th
CNTRL+SHIFT+ENTER. But nothing

flapokey :confused

 

[Bob Phillips]

I have posted an example at http://cjoint.com/confirm.php?cjoint=iFldmrQO4p
which you can play with

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[flapokey]

Thank You

I guess I wasn't doing something right before it works fine thank you.


flapokey :