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.





Ashish Mathur Wrote:
Hi,

Array entet the following formula (Ctrl+Shift+Enter)

=SUM(IF((A2:A6=A8)*(B2:B6=1),C2:C6))

You can also use the DSUM function.

Regards,

"yak10" wrote:
-

Hi everyone, first post for me,

I have been using the sumif function the last couple days and I've
was
wondering if there is anyway to have more than 1 range and criteria
for
this function or is there another function where I can do this?
Below
might better illustrate what I'm trying to do:

Column 1 Column 2 Column 3
Blue One 100
Blue One 100
Red One 100
Red Two 200

I want the sum of column 3, if column 1 equals blue AND column 2
equals
One. So my answer in this case is 200.


--
yak10
-


--
yak10