Actually I did get it to work now, thanks


yak10 Wrote:
None of these are working for me, I'm pretty sure that sumproduct is not
what I want. This has to be a logical function. Sumproduct is not a
logical function. I think Ashish is on the right track but it keeps
coming back as either 0 (when it should be 200 from my original post)
or #VALUE error. I need the sum of a column if 2 conditions are
fulfilled.


--
yak10