G
Guest
Question:
A B C
123 20/30 $100
123 30/30 $200
456 20/30 $300
I want to sum up total in column C with the following conditions:
if column A =123 AND column B = 20/30 or 30/30
Result should be: $300
When I do a sumproduct with text, it works well ... but it doesn't work with
numbers.
Please help. Thank you
A B C
123 20/30 $100
123 30/30 $200
456 20/30 $300
I want to sum up total in column C with the following conditions:
if column A =123 AND column B = 20/30 or 30/30
Result should be: $300
When I do a sumproduct with text, it works well ... but it doesn't work with
numbers.
Please help. Thank you