View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Dvorkin Mark Dvorkin is offline
external usenet poster
 
Posts: 10
Default how to average a cell value across worksheets?

Hello,

I have a workbook containing upto 30 worksheets, i.e.
at any given time there could be any number of sheets
from 1 to 30

I'd like to have a function which would average values
in one particular cell across the sheets prior to the call
(from sheet1 to the sheet where the function is called).

Could somebody please get me started on this one.

Thanks in advance,
Mark