Try...

=IF(SUM((DateTODAY()-30)*Readings),AVERAGE(IF((DateTODAY()-30)*(Reading
s0),Readings)),"")

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
"Sick Puppy" wrote:

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