SUMIF across multiple sheets?

[Wrathor]

Is it possible to do a sumif across multiple sheets?

I have 212 sheets with data in A3:G90.
The values in A3:A90 always start with year 14 and count up from there.
The values in B3:B90 start anywhere from age 49 to age 80, and count up until they reach age 99 then stop.

On a Composite sheet, I'm trying to sum the values in columns G when 99 falls under the year in column A.

The formula I tried is: =SUMIF('Sheet1:Sheet212'!B3,99,'Sheet1:Sheet212'!G3)

This formula is returning a value error.

Any suggestions?

 

[pgc01]

I'm glad it helped. Thanks for the feedback.