Hi
sorry,
was just a typoe. Try.
=AVERAGE(A1:A31)

--
Regards
Frank Kabel
Frankfurt, Germany

"Randy Lefferts" schrieb im
Newsbeitrag ...
Thank you for the replies :)

Unfortunately I may not have included enough information
since the formula "=AVERAGE(A1:31)" is generating
an "incorrect" number. I apologize for not including
pertinent information.

The column that contains the data that is to be averaged,
contains formulas to get the number(s) that I want to
average.

So instead of A1 containing just a number, it contains
the formula =(BN13-BM13)+(BP13-BO13). This is true for
each cell in the column that I want to average.

Thoughts?


-----Original Message-----
Hi
=AVERAGE(A1:A31)

blank cells and strings are ignored

--
Regards
Frank Kabel
Frankfurt, Germany

"Randy Lefferts"
schrieb im
Newsbeitrag news:16d501c4d6e7$46e0bee0
...
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

.