View Single Post
  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
=AVERAGE(A1:A31)

blank cells and strings are ignored

--
Regards
Frank Kabel
Frankfurt, Germany

"Randy Lefferts" schrieb im
Newsbeitrag ...
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