Excel sum function

Question

Hey Guys, I use to have a formula for summing the values across multiple sheets and lost that formula. My brain is hurting now because this should be easy and I stabbed my brain with a q-tip this morning.

What I am trying to do is on the "Boxes" sheet C6 ( fig 1) is go through all the Sheets (fig 2) "1988 Tops", 1988 Topps-Glossy All Stars" "1989 Topps" etc. There is about 80 sheets to be summed and I figure if I can get the formula for 3 sheets I can expand it to all my sheets. All the sheets to be summed are set up the exact same way. Plus when I add sheets at a later date as long as I add sheets in-between the first sheet and the last sheet they should be included in the formula. So I need sum K22 on all sheets

fig -2

2

Answer 1

Use

=SUM('First Sheet:Last Sheet'!K22)

For example:

=SUM('1988 Topps - Glossy All-Stars:1989 Topps'!K22)