Combining multiple SUMIFS in one formula

[shaunguyver]

I have the following SUMIFS formula, which works well:

=SUMIFS('Sheet1'!A1:A100,'Sheet1'!B1:B100,"Jones")

This sums the total number of values in Column A associated with any instance of 'Jones' in Column B.

However, I need to do the same for 2 other sheets but combine the total in one formula. Is this possible?

[Sam Capricci]

yes, take the sumifs and put + then the next sumifs stmt + next sumifs stmt.

EDIT: =sumifs(formula)+sumifs(next sheet formula)+sumifs(next sheet formula) should work for you.

[shaunguyver]

That's worked perfectly, didn't realise it was that straightforward. Thanks guys!