Average value of A1 on every sheet in the workbook?

**svaiskau** · 08-07-2008, 02:03 PM

Greetings.

I have a dashboard sheet that contains summaries of data from every other worksheet in the book. I need to average the values of A1 on every sheet. How would I go about doing this?

Thanks.

**Leith Ross** · 08-07-2008, 02:16 PM

Hello svaiskau,

Have a look at this post http://www.excelforum.com/showthread.php?t=652170

Sincerely,
Leith Ross

**svaiskau** · 08-07-2008, 04:03 PM

Thanks for the help.

I thought if I started simple I could figure it out, but I can't.

I'm going to upload the .xls because it's too confusing for me to explain. It tracks my golf scores, each round on a different sheet, and generates statistics on a single (front) page.

I need a function that I can pass the common cell, and the number of rounds, and it will return the average value of that cell over the X most recent rounds.

All rounds will have the date in A1. No other sheets will have anything in A1.

How do I go about determining which sheets should be included in the average?

Thanks in advance for the help, I know this is a big request.