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
>


 | 
Pages: 1
Prev: Excel file size increased 3 times after saving!!!!
Next: Using Iserror with If statement and Vlookup