that includes zero values in the average for me. are they blanks and not zeroes?

--


Gary Keramidas
Excel 2003


"Mike" wrote in message
...
This is what i have & it works but one problem there will be zero values & i
need to exclude them if possible
=AVERAGE(IF(AA5="L",E$5:E$65))
I have tried several different combinations I can,t get it