Sum based on multiple selection criteria

Originally Posted by mcnallyb2

Thanks, Tony. But what is the syntax across sheets? I can't get it to work.

You didn't mention that the formula needs to work across multiple sheets.

That changes things significantly!

What are the real sheet names?