Average a column that contains one cell of text

  • Thread starter Thread starter Malcolm
  • Start date Start date
M

Malcolm

What formula do I use to average a column of numbers that contain one cell
with text? I'm using Excel 2007
 
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

Similar Threads

Average columns that contain text 2
Averaging a column that contains text 4
countifs Function not giving desired result with date criteria 2
#DIV error 2
Average range of discontinuous cells 1
Excel Average dates help 0
SUMIF with criteria "<>" & "=" 4
Averaging two ranges on the same column (excluding zeros) 2

Back
Top