Quantity summing with 2 checks

[shaked]

I need to compare two columns of data with the goal of pulling information from a single column that involves both. I need to count the quantity if it checks out.

So let's say column A and B are the columns I'm checking and C contains the data used if they pass.

if A1:A100 = X and B1:B100 = Y, SUM positive results in that row c1:c100

so let's say a1, a5, a7, a9 are X and only b1 and b7 are Y. I want to sum the values of c1 and c7.

I will be checking about 20 values of X and 10 values of Y. What's the plan of attack?

[shg]

=sumproduct( (a1:a100= "x") * (b1:b100 = "y") * c1:c100) )

[shaked]

I'm checking two unrelated ideas with a similar quantity. In this case, I'm checking material vs diameter and then I'm taking the quantity produced.

Essentially, I'm separating data that appears multiple times. There are multiple 3" diameter parts that are not always made of the same material. The material is say 1-10. So I want to separate material 1 from material 8 even though both are 3" in diameter. Right now I can only sum based on one variable (diameter) via sumif(a1:a100, cell, c1:c100). I need to add that second variable.

I hope that clarifies my issue.

[shg]

So ... did you try the formula?