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 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.
