Averaging across multiple sheets with#div0 errors

P

Peter Atherton

Hi

Sometimes you have to walk away. The error is in the
average so

=IF(ISERROR(AVERAGE(Sheet1:Sheet3!B5)),"",AVERAGE
(Sheet1:Sheet3!B5))

Hope you see the post!

email (e-mail address removed)
regards
Peter
 
P

peterj

=SUM(Sheet1:Sheet3!A1)/COUNT(Sheet1:Sheet3!A1)

will produce the average of all non blank entries in cell A1 betwee
sheet 1 and sheet 3

Hope this helps
Pete
 

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

IF across multiple worksheets 9
Average formula across future worksheets 2
averaging range across sheets after transforming text to value 2
A useful AVERAGE calculation without using the built-in AVERAGE function 3
Trying to average the contents of a cell across multiple worksheet 12
Average Over Multiple Sheet Tabs with Multiple Values 6
1 cell average across multiple worksheets 8
Calculate Average in pivot item 6

Top