Two conditions in a SUMIF function

[Guest]

I am trying to sum a list of numbers but I have two different critia that I
need sorted by. One is week number and the other is Camp Name.

So for the following

Money Week Camp
200 2 Teen
250 1 Teen
320 2 Rock

I would like to be able to input sum money if colume B=1 and C=Teen and
return 200 instead of 450 or 520.

If anyone knows how do that this a little help would be great

 

[Sandy Mann]

I would like to be able to input sum money if colume B=1 and C=Teen and

return 200

Don't you mean 250 or if B=2?

Anyway try:

=SUMPRODUCT((B2:B4=1)*(C2:C4="Teen")*A2:A4)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

Thank you and yes I did mean 250

Don't you mean 250 or if B=2?

Anyway try:

=SUMPRODUCT((B2:B4=1)*(C2:C4="Teen")*A2:A4)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

You're vary welcome.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk