I've got what is probably a fairly simple problem, but the answer is just not coming to me right now.
I need to formula to add up a commission array E5:E10 if either of two adjacent arrays, C5:C10 or D5:D10, has a "Y" in it. In the attached spreadsheet, the correct total would be 120.
I'm pretty sure SUMIF can only have one condition, so I "believe" I need to use SUMPRODUCT formula. But most of the instances where I've used a SUMPRODUCT is where I'm test two or three conditions to all be true, such as =SUMPRODUCT ((condition1)*(condition2)
But in my current situation, the logic is "if condition 1 or
condition 2 multiply array." I'm just not sure how to format the OR condition.
Or if there is a better way to do it, I'm all ears. :-)