Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF with two conditions | Excel Worksheet Functions | |||
Sumif with two conditions? | Excel Worksheet Functions | |||
SUMIF 2 conditions are met??? | Excel Worksheet Functions | |||
SUMIF function with 2 conditions | Excel Worksheet Functions | |||
How do you do a SUMIF function with 2 different conditions? | Excel Worksheet Functions |