SUM IFS across two sheets

Occasional Visitor



Trying to do a SUMIF across two sheets given 3 parameters to return one desired output. I have been playing around with IF(AND functions advanced Vlookup, IndexMatch etc. Went through some videos as well. Can someone provide me a documentation for SUMIFS across two worksheets?

1 Reply


With just two sheets, I'd simply add two SUMIF formulas together:


=SUMIF(arguments for sheet1)+SUMIF(arguments for sheet2)


If you need to do this for a large number of sheets, there is a more efficient method.