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??