Averaging non contiguous numbers

  • Thread starter Thread starter ssg
  • Start date Start date
S

ssg

I want to average numbers from different columns that are not contiguous. I
also do not want to include any zeros in the average. Is it possible to use
the Average/If function to do this. When I try to enter the different
columns separated by commas, I get a message that there are too many
arguments. I am using Excel 2003
 

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 of non contigous data to also exclude zeros 14
Excel Issue with "Average" showing in Status Bar 2
Averaging Number above Zero 6
Average Formula Help 2
Need help with a formula 3
Averages 7
selecting non-contiguous cells 1
AVERAGEing non contiguous rows 2

Back
Top