=SUMPRODUCT(--(A2:A20),--(B2:B20="Spring"),--(C2:C20="Green"))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"stanasia" wrote in message
...
Hello,

I am knowledgable how to get a SumIf from one column based one or more
criterias from only one other column. However, now I need to compare
criteria
from two different columns and return the SumIf from a third column. I
tried
Concantenation, but to no avail and even tried nesting If functions but
still
no avail. Can anyone help?

Below is the scenario:

Col A Col B Col C
52 Winter Pink
23 Spring Pink
6 Fall Green
10 Winter Blue
30 Summer Green
10 Fall Blue
5 Spring Green
45 Winter Green
80 Fall Pink
12 Summer Pink
34 Summer Blue

Now how do I return the sum of Col A for all criteria that meets Spring =
Green or Pink + Fall = Green or Pink based on Col's B & C?. And only the
sum
of those criterias?