It may be simpler using SUMIF here because SUMIF won't give an error if the person isn't found on any particular sheet (although all sheets need to exist), so if you have sheets "jan" through to "dec" try this formula for the 12 month total

=SUM(SUMIF(INDIRECT({"jan";"feb";"mar";"apr";"may";"jun";"jul";"aug";"sep";"oct";"nov";"dec"}&amp;"!B8:B110"),B8,INDIRECT({"jan";"feb";"mar";"apr";"may";"jun";"jul";"aug";"sep";"oct";"nov";"dec"}&amp;"!AL8:AL110")))

You can shorten that by using a named range, e.g.

Sheetlist ={"jan";"feb";"mar";"apr";"may";"jun";"jul";"aug";"sep";"oct";"nov";"dec"}

then formula becomes

=SUMPRODUCT(SUMIF(INDIRECT(Sheetlist&amp;"!B8:B110"),B8,INDIRECT(Sheetlist&amp;"!AL8:AL110")))

Sum of vlookup values on multiple sheets
On my last trip to the Baltic, the cruise ship docked at Nynäshamn, about an hour's drive (each way) from Stockholm. To get ashore, we had to use a tender boat, which took up even more time. Apparently, a lot of travelers to Stockholm get there this way.

Is Nynäshamn a better port? Is it much cheaper to dock there than in the capital city? Or is it an important tourist attraction in its own right that should be given equal attention with Stockholm?
