Look up and average multiple values from multiple sheets

You'll need to do some 3-D SUMIFs and COUNTIFs.

Somewhere, make a list of the sheet names you want to reference.

Select that list of names, go to Formula, Name Manager, and give that selection a new name. I called mine Sheets.

B2:

Please Login or Register  to view this content.

B3:

Please Login or Register  to view this content.

B4:

Please Login or Register  to view this content.

B5:

Please Login or Register  to view this content.

and copy all four rows across.

Thanks! Sorry it took me so long to get back to you. I was wrestling with some issues on this where I kept getting reference errors, but then I found out that I couldn't use spaces in my tab names. No issues once I found that out! Thank you very much!

You can use space characters in sheet names but you have to use quotes around the names when you refer to them in formulas.

"'"&Sheets&"'!C2:C6"

In "exploded view"...

" ' " & Sheets & " ' ! C2:C6 "