SUMIF function for multiple sheets

Can the SUMIF function be used for adding values that meet certain criteria over multiple sheets? I'm trying to create a formula that will search for a given name over 30-plus sheets and, if found, it will add the numbers given in another cell. I have had a similar problem just counting for names over multiple sheets, and was directed to use the Morefunc addin (=COUNTIF.3D), which worked perfectly. However, I was hoping it would also contain a function that would work the same way for SUMIF but I can't figure it out. Any help on this matter would be much appreciated. Thanks!

it is returning a #REF! error. the formula i entered is:

=SUMPRODUCT((THREED('Daytona 2-17:Homestead 11-16'!A3:A4)=B2)*(THREED('Daytona 2-17:Homestead 11-16'!F3:F4)))

there are sheets later that have no values in them yet because the events have not taken place, would that be an issue?

This is probably a moot point because you already have morefunc installed, but you can do it without morefunc. Assume you have your sheets you want to sum listed in a range somewhere (eg Z1:Z30 of the sheet the formula is on) then:

=SUMPRODUCT(SUMIF(INDIRECT("'" & Z1:Z30 & "'!A3:A4"),B2,INDIRECT("'" & Z1:Z30 & "'!F3:F4")))

Richard