in [Functions]

Prev: Excel file size increased 3 times after saving!!!!
Next: Using Iserror with If statement and Vlookup
From: mirko on 12 Mar 2010 09:22 Hi, how do I create a formula to sumarize value by group and subgroup? My formula by group works but unfortunately the 2nd one doesn't work. What I need is : sumarize the value (column D ) of all products having group = A and subgroup = A. total group subgroup value by_gr by_subgr A A 10 A A 20 A B 30 B A 40 B A 50 B B 60 C A 70 C B 80 D A 90 D B 10 60 =SUMIF(A2:A12;"A";C2:C12) this is OK total 460 something like this: =SUMIF(A2:A12;"A".... AND ...B2:B12;"A";C2:C12) ??? Thanks in advance, mirko
From: Eduardo on 12 Mar 2010 09:28 Hi =SUMPRODUCT(--(A1:A12="A"),--(B1:B12="A"),D1:D12) "mirko" wrote: > Hi, how do I create a formula to sumarize value by group and subgroup? My > formula by group works but unfortunately the 2nd one doesn't work. > What I need is : sumarize the value (column D ) of all products having group > = A and subgroup = A. > total > group subgroup value by_gr by_subgr > A A 10 > A A 20 > A B 30 > B A 40 > B A 50 > B B 60 > C A 70 > C B 80 > D A 90 > D B 10 60 =SUMIF(A2:A12;"A";C2:C12) this is OK > total 460 > > something like this: =SUMIF(A2:A12;"A".... AND ...B2:B12;"A";C2:C12) ??? > > Thanks in advance, > mirko >
From: Bob Phillips on 12 Mar 2010 09:49
try =SUMPRODUCT(--(A1:A12&B1:B12="AA"),C1:C12) -- HTH Bob "mirko" <mirko (a)discussions.microsoft.com> wrote in message news:A74A793D-95C5-4280-81A3-743E1C47145A (a)microsoft.com...> Hi, how do I create a formula to sumarize value by group and subgroup? My > formula by group works but unfortunately the 2nd one doesn't work. > What I need is : sumarize the value (column D ) of all products having > group > = A and subgroup = A. > total > group subgroup value by_gr by_subgr > A A 10 > A A 20 > A B 30 > B A 40 > B A 50 > B B 60 > C A 70 > C B 80 > D A 90 > D B 10 60 =SUMIF(A2:A12;"A";C2:C12) this is OK > total 460 > > something like this: =SUMIF(A2:A12;"A".... AND ...B2:B12;"A";C2:C12) ??? > > Thanks in advance, > mirko > |