Averaging across all worksheets except one

T

theswener

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
 
G

Guest

I'm not sure I fully understand the question but if you simply want the
average of the same cell in multiple worksheets then this will average A1 in
all worksheets.

=AVERAGE(Sheet1:Sheet10!A1)

Repalace sheet1 with the first sheet and sheet 10 with the last sheets in
the book that you want to average

Mike
 

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

averaging from different sheets and folders 1
Average across worksheets ignoring zero 2
summary values across worksheets within the same workbook 2
Lookup across multiple worksheets 14
Reference(s) to worksheets for building graphs 4
Average across selected worksheets 1
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7
Excel, assign cells in multiple worksheets from one sheet 1

Top