View Single Post
  #1   Report Post  
Randy Lefferts
 
Posts: n/a
Default Averaging only cells with data

I have a column with 31 rows. In select cells, there is
a number. I want to average the numbers. How do I
average only the cells that contain data, ignoring blank
cells? Thanks!

Excel 2003