PDA

View Full Version : [SOLVED] Adding two columns together with two criteria

oam
03-06-2018, 09:28 PM
I would like to have a formula that will add together data from two different worksheets. The below SUMPRODUCT formula works well for finding the data with two criteria on one sheet but I need a way to combine the two formulas together so the result would be the total from the both formulas.

Hope this make sense! Thank you for any and all help

SUMPRODUCT(--(Sheet1!\$A2:\$A10000=\$A3),--( Sheet1!\$B2:\$B10000=B\$1),--( Sheet1!\$C2:\$C10000))
SUMPRODUCT(--(Sheet2!\$A2:\$A10000=\$A3),--( Sheet2!\$B2:\$B10000=B\$1),--( Sheet2!\$C2:\$C10000))

example:
SUMPRODUCT(--(Sheet1!\$A2:\$A10000=\$A3),--( Sheet1!\$B2:\$B10000=B\$1),--( Sheet1!\$C2:\$C10000))+SUMPRODUCT(--(Sheet2!\$A2:\$A10000=\$A3),--( Sheet2!\$B2:\$B10000=B\$1),--( Sheet2!\$C2:\$C10000))

SamT
03-08-2018, 09:55 AM
Moderator Bump

Bob Phillips
04-22-2018, 02:56 PM
What is wrong with the formula that you gave, does it not do what you ask?

oam
04-22-2018, 03:46 PM
It does, that is why I marked the post Solved but thank you for checking back with a solution.