Two conditions in a SUMIF function

T

Tim

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
 
S

Sandy Mann

I would like to be able to input sum money if colume B=1 and C=Teen and
return 200
Click to expand...

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
T

Tim

Thank you and yes I did mean 250

Sandy Mann said:
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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
S

Sandy Mann

You're vary welcome.

--
Regards,

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top