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.