Help with SUMIF & AND function
 

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

Help with SUMIF & AND function
 

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

Help with SUMIF & AND function
 

try

=SUMPRODUCT(--(A1:A12&B1:B12="AA"),C1:C12)

--

HTH

Bob

"mirko" wrote in message
...
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