I used
=IF(N14:N65536=0,"",AVERAGE(IF((DateTODAY()-30)*(Readings0),Readings)))
with a CTRL-SHIFT-ENTER to confirm it and it seemed to work. If I have
trouble I'll try the white text idea -- which, incidentally, is a cool idea.
Hmmmm.... maybe I like the white text way even better, Domenic. I'll give
it a try.
THANKS ONCE MORE!!
Tim
From: The Mountain, Cough Drop Div.
···· Date & Time Composed ····
June 22, 2005
6:22 pm EASTERN STANDARD TIME -- USA
|