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" <flapokey.1ul76i_1125421581.3026@excelforum-nospam.com> wrote in
message news:flapokey.1ul76i_1125421581.3026@excelforum-nospam.com...
>
> 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
>

[flapokey]

Hello,

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

flapokey

[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" <flapokey.1ulyyd_1125457540.4211@excelforum-nospam.com> wrote in
message news:flapokey.1ulyyd_1125457540.4211@excelforum-nospam.com...
>
> Hello,
>
> Thank you for your help, but the fomula did not work. I did the
> CNTRL+SHIFT+ENTER. But nothing
>
> flapokey
>
>
> --
> flapokey
> ------------------------------------------------------------------------
> flapokey's Profile:
http://www.excelforum.com/member.php...o&userid=26690
> View this thread: http://www.excelforum.com/showthread...hreadid=400503
>

[flapokey]

Thank You

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


flapokey