Thread: SumProduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sweepea Sweepea is offline
external usenet poster
 
Posts: 28
Default SumProduct

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