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
|