SUM IFS across two sheets

Copper Contributor

Hello, 

 

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

@Mia_0101 

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.