View Single Post
  #9   Report Post  
Sick Puppy
 
Posts: n/a
Default

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