May 24 2022 03:36 PM
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?
May 25 2022 12:55 AM
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.