Help with SumProduct Formula

Basically I have 3 ranges (Range A, B, C)

I'm looking for a formula that will sumproduct ranges A and B, a value of which is equal to the sumproduct of ranges A and C, where ranges B and C contain different values. Cells in range C are equal to 1 if there if the cells in range B are populated.

So in my example, I need a formula in cell L3 that produces the same value in cell L4, using the numbers in Range C instead of Range B.

Thank you

Hi Brent_Excel,

Although I'm not an expert in Excel, however, from your attached example, I wonder if it's even possible to have an answer in the first place. Reason being, As Range C is populated, Range B will have a value of 1, if not 0. Thus, no matter what the value in Range A is, it will be 0, since any value in A multiply by 0 gives 0.

Secondly, SumProduct, in your example, takes the value of each range in A multiply each value in range B, as well as in range C. But since Range B can only shows as 1 IF AND ONLY IF Range C is is populated, AT BEST, SumProduct of Range A and Range B will be equal to The SUM of Range A itself.

I agree with dluhut. The only way to get the same answers is if both ranges B and C contain 1 or 0 in the same columns. Otherwise they will not sumproduct to the same number.

That is PERFECT. SOLVED. Thank you very much!!!

(I should have clarified to the other responders - I don't necessarily need to use the sumproduct function if using another function, in this case SUMif, will produce a similar result)