Try:
Sumproduct((Column1 Range="Blue")*(Column2 Range="One")*(Column3 Range))
All three ranges must be the same length
HTH
Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk
"yak10" wrote in message
...
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
|