Average a column that contains one cell of text



What formula do I use to average a column of numbers that contain one cell
with text? I'm using Excel 2007

T. Valko

The AVERAGE function will ignore text (in an array).

How do you want to handle that one cell with text?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question