Thread: Average Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sross002
 
Posts: n/a
Default Average Formula

how do I Calculate the average of numbers not in a contiguous row or column,
excluding cells that have 0?

(The column starts at F5 but I will continuosly add to the f column, so it
doesn't have an ending column.)

It's a simple worksheet calculating my MPG on my car, so I will keep adding
to it.