formula lost

**Zrx** · 12-03-2006, 05:34 PM

Hello Guys,

I have been chasing this little devil for some time now and I'm fed up!!

I put a formula in cells formula bar and whenever it decides by itself poof its gone!!!

example formula would be say (in formula bar)

=SUMPRODUCT(--($A$5:$A$200>(h4/24)),--($A$5:$A$200<(h5/24)))

in say cell g31 with answer in cell 31.

Now it just dawn on me, this is an array correct so ctrol,shift, enter may be needed?? If so why do other cells with same idea work??

**VBA Noob** · 12-03-2006, 05:37 PM

Hi,

It's not an array.

Are you clicking the X instead of the tick or pressing return

VBA Noob

**Zrx** · 12-03-2006, 05:58 PM

clicking the "green" check mark and also tried enter key. Seems to work sometimes and not others. Did a total re-install of excell 2003 which made no diff.