Forum Discussion
SUM IFS across two sheets
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 som...
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.