SUMIF function
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
|