HELP!!! I need HELP with a array formula PLEASE !!!!

[flapokey]

Hello,

Here is the ARRAY Formula I have and this is what I am using it for.
The situation is that it worked 1 time and than not again.

=INDEX(D48:K48,,MAX(IF(D48:K48<>"",COLUMN(D48:K48)))-COLUMN(D48)+1


Duty:

I have a row of number that appear hourly (DOLLAR AMOUNTS), the number
are anything from nothing to 10000. I want the hourly number to appear
in specified cell. Here is an example. (I am using EXCEL 2000)

Row D48:K48 answer in cell G2


1st hour
D48 = $100.00 G2 Should be $100.00

2nd Hour
D48 = $100.00 E48 = (nothing) G2 Should be (nothing)

3rd Hour
D48 = $100.00 E48 = (nothing) F48 = $230.00 G2 Should be $230.00

4th Hour
D48 = $100.00 E48 = (nothing) F48 = $230.00 G48 = $56.00 G2 Should be
$56.00

5th Hour
D48 = $100.00 E48 = (nothing) F48 = $230.00 G48 = $56.00 H48 = $456.34
G2 Should be $456.34

6th Hour
D48 = $100.00 E48 = (nothing) F48 = $230.00 G48 = $56.00 H48 = $456.34
I48=(nothing) G2 Should be (nothing)

7th Hour
D48 = $100.00 E48 = (nothing) F48 = $230.00 G48 = $56.00 H48 = $456.34
I48=(nothing) J48=$789.52 G2 Should be $789.52

8th Hour
D48 = $100.00 E48 = (nothing) F48 = $230.00 G48 = $56.00 H48 = $456.34
I48=(nothing) J48=$789.52 K48= $45.67 G2 Should be $45.67

As I said this array formula worked 1 or 2 times and than nothing. (I
did do the cntrl+shift+enter)

I want G2 to be blank when nothing is in the correct time in D48:K48.

What shows in G2 now is Blank the cell is blank, nothing no matter what
is entered in to D48:K48.

I have tried to retype it and cntrl+shift+enter. Nothing !!!

Can someone help me

flapokey

 

[Max]

Think there's a missing param, i.e. the hour
(How would your posted formula know which hour it is?)

Let's assume H2 is where the numbers: 1 - 8 (for the hour)
will be input / evaluated

Then we could just put in G2:
=IF(OR(H2="",H2>8),"",IF(INDEX(D48:K48,,H2)=0,"",INDEX(D48:K48,,H2)))

 

[flapokey]

Hello,

This amount that I am trying to move (to G2) is put in the cell
(D48:K48) automatically from another formula. Every hour I put othe
information in this table and several formulas are at work to give m
different figures. This is one of others working. So what I need i
when the appropiate cell is filled each hour than I need that total o
figure to move from the cell to another cell. But I need to new cell
information. I hope this helped. I did try to give the best exaple i
the post. The only thing is that there could be a hour where nothin
is put in the cell and that needs to be moved to G2. Yes a BLANK i
that is what is there. So I will try to give another example.

There are 8 cells for this to happen 1 for each hour

hour 1 the cell (D48) total is $200.00 well in cell G2 should rea
$200.00

hour 2 the cell (E48) total is (BLANK) NOTHING! well in cell G2 shoul
read ___ nothing!

hour 3 the cell (F48) total is $658.25 well in cell G2 should rea
$658.25

And so on for the rest of the cells. EVEN IF IT IS BLANK I NEED T
PROTRAY THAT IN G2.

Thanks flapokey :confused