=AVERAGE(A1:M1)

average ignores the text cells

--
HTH

Bob Phillips

"Brad Hubeny" <Brad wrote in message
...
Hi all,
I have a column of numerical data in which there are randomly spaced text
boxes (ie different spacing between text entries). I am looking for a way
to
average cells between the text boxes. I can do this individually by
selecting cell ranges, however I am interested to know if anyone has a way
to
do this automatically (or at least more quickly!). Any thoughts would be
appreciated!
Thanks,
Brad Hubeny