averaging

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi
If I want to obtain the average of values in a column, using only those
cells which have a value in them, which function do I use please?

thanks
A
 
Use =average()
it ignores cells that are empty and cells that contain text.
 
You must log in or register to reply here.

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 Question 2
Average of cells from a table given certain criteria 2
Take an average of data where lookup in array is needed 3
=AVERAGE (see underlying values?) 7
averaging numbers 5
average function and error/missing values - inconsistant behavior! 8
Averages 4
Possible solution using Array Formula 2

Back
Top