Thread
:
Two conditions in a SUMIF function
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Tim
external usenet poster
Posts: 408
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
Reply With Quote
Tim
View Public Profile
Find all posts by Tim