View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] theswener@gmail.com is offline
external usenet poster
 
Posts: 1
Default Averaging across all worksheets except one

Hello,

I want to find the average value of one cell in every sheet in a
workbook, and display it on another sheet (preferably in the same
cell). If this is put in the same cell, that means that one sheet must
be left out of the averaging.

This is for a budget, so I will be constantly adding sheets, and will
not know the total number of sheets, so I want to call out something
like "= average[ cell() in all sheets except 'Summary']."


Anyone have suggestions for how to code this? Thanks a bunch!

Rob