If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|