View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Averaging non contiguous numbers

Is there a pattern to the cells you want to average?

--
Biff
Microsoft Excel MVP


"ssg" wrote in message
...
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
--
ssg