Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif multiple criteria?
ok, I am using sumif to add columns with particular names next to them, but I
am selecting the names from a dropdown list A1 B1 C1 D1 E1 F1 amount Name Reason (selectN) (selectR) £ £24 smith 56 X X =? So I'm using Sumif to total all of "smiths" Sales in one cell, but I want to Add all of his sales for one reason code is there a way to use sumif with more than one criterion? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif multiple criteria?
No, but you can use SUMPRODUCT
=SUMPRODUCT(--(B2:B200="smith"),--(C2:C200=56),A2:A200) Note that SUMPRODUCT doesn't work with complete columns, you have to specify a range. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alan" wrote in message ... ok, I am using sumif to add columns with particular names next to them, but I am selecting the names from a dropdown list A1 B1 C1 D1 E1 F1 amount Name Reason (selectN) (selectR) £ £24 smith 56 X X =? So I'm using Sumif to total all of "smiths" Sales in one cell, but I want to Add all of his sales for one reason code is there a way to use sumif with more than one criterion? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif multiple criteria?
so, will that only add up totals in column A if a) the name is "smith", and
b) the reason code is "56"? -- [RLK] Rollin' Like Kingz "Bob Phillips" wrote: No, but you can use SUMPRODUCT =SUMPRODUCT(--(B2:B200="smith"),--(C2:C200=56),A2:A200) Note that SUMPRODUCT doesn't work with complete columns, you have to specify a range. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alan" wrote in message ... ok, I am using sumif to add columns with particular names next to them, but I am selecting the names from a dropdown list A1 B1 C1 D1 E1 F1 amount Name Reason (selectN) (selectR) £ £24 smith 56 X X =? So I'm using Sumif to total all of "smiths" Sales in one cell, but I want to Add all of his sales for one reason code is there a way to use sumif with more than one criterion? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif multiple criteria?
Yes. Try it and see.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alan" wrote in message ... so, will that only add up totals in column A if a) the name is "smith", and b) the reason code is "56"? -- [RLK] Rollin' Like Kingz "Bob Phillips" wrote: No, but you can use SUMPRODUCT =SUMPRODUCT(--(B2:B200="smith"),--(C2:C200=56),A2:A200) Note that SUMPRODUCT doesn't work with complete columns, you have to specify a range. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alan" wrote in message ... ok, I am using sumif to add columns with particular names next to them, but I am selecting the names from a dropdown list A1 B1 C1 D1 E1 F1 amount Name Reason (selectN) (selectR) £ £24 smith 56 X X =? So I'm using Sumif to total all of "smiths" Sales in one cell, but I want to Add all of his sales for one reason code is there a way to use sumif with more than one criterion? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF, multiple criteria | Excel Worksheet Functions | |||
SUMIF multiple criteria | Excel Worksheet Functions | |||
sumif multiple criteria | Excel Worksheet Functions | |||
SUMIF with multiple criteria | Excel Discussion (Misc queries) | |||
SUMIF With Multiple Criteria | Excel Worksheet Functions |