View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim Tim is offline
external usenet poster
 
Posts: 408
Default How to create spreadsheet that averages up to 10 columns of data

I want to average up to 10 columns of data,and display the information into 4
percentages. I would like to use the same spreadsheet to average less than
10 columns, as well. My question is how to set up the spreadsheet to average
the information based on the number of columns. I have it set up to average
everything as long as I have 10 sets of information, but sometimes I will
only use 7 or 8, etcc.....