Two conditions in a SUMIF function
 

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

Two conditions in a SUMIF function
 

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


Replace @mailinator.com with @tiscali.co.uk


"Tim" wrote in message
...
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

Two conditions in a SUMIF function
 

Thank you and yes I did mean 250

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"Tim" wrote in message
...
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

Two conditions in a SUMIF function
 

You're vary welcome.

--
Regards,

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


Replace @mailinator.com with @tiscali.co.uk


"Tim" wrote in message
...
Thank you and yes I did mean 250

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"Tim" wrote in message
...
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