need help with a function in excel

[ritcH]

I'll try my best to describe what I want to do:

I want to calculate a number in my budget table but only if other conditions elsewhere in the worksheet are true.

So in column A1 to A6 I have 3 potential values: gp1, gp2, gp3 eg.,

A
gp1
gp2
gp1
gp3
gp1
gp2

Then in column B1 to B6 I also have 3 potential values: act, comm & est eg.,

B
act
comm
est
act
comm
act

Then in colum C1 to C6 I have prices e.g.,

C
£150
£120
£80
£90
£110
£170

Now what I want to do is return a value in D1, which is the sum of the prices in C1:C6 only if certain conditions are met. So my question is how do I sum the price in C1:C6 if A1:A6 equals "gp1" AND IF B1:B6 equals "act"?!?!?

Please, please help this is driving me crazy!

Note: this is not homework, this is real work - trying to make a spreadsheet for budget data.

 

[MarcLister]

Would the SUMIF function not do this for you?

 

[moid]

sumproduct:


=sumproduct(--(A1:A6="GP1"),--(B1:B6="GP2"),(C1:C6))

 

[ritcH]

I don't know how to make SUMIF work for more than one condition, here I have two. I'll try the other suggestion, though.

Thanks for any and all help!

edit: moid, that's just beautiful, thank you!

edit2: maybe in the interests of learning you could describe how the function works?

edit3: http://img141.imageshack.us/img141/3144/probsolvedkl6.png