View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
outrigger outrigger is offline
external usenet poster
 
Posts: 9
Default =AVERAGE(b7:b20) is counting fiels that are zero

I brought cell information from worksheet B into worksheet A, by typing = in
a cell and then clicking on cell in worksheet B and hitting enter. Data in
that cell is empty. So excell placed a "0" in the final cell. When I average
the column it of course adds the zero's. I don't want it to do that, only
the numbers gtreater that '0". How do I get this accomplished?