sum product sum if conditional HELP!!!
 

I want to add up specific rows is a condition is satisfied.
whenever there is a Y in the first table I want to add up the corresponding
values in the 3 tables below
I have tried a sumif sum but that hasn't worked, can anyone please help
me??

A B C D E
1
2 JAN FEB MARCH
3 A Y Y
4
5 COMP A JAN FEB MARCH
6 1 2 3
7
8 COMP B JAN FEB MARCH
9 4 2 6
10
11 COMP C JAN FEB MARCH
12 3 1 1
13
14 = (1+2)+(4+2)+(3+1) <------------ sum I want
15
16 = SUMIF(B3:D3,Y,(B6:D6,B9:D9,B12:D12))

sum product sum if conditional HELP!!!
 

You can't use sumif but can use SUM

=SUM(B6:B12)*(--(B3="Y"))+SUM(C6:C12)*--(C3="Y")+SUM(D6:D12)*--(D3="Y")

"laandmc" wrote:

I want to add up specific rows is a condition is satisfied.
whenever there is a Y in the first table I want to add up the corresponding
values in the 3 tables below
I have tried a sumif sum but that hasn't worked, can anyone please help
me??

A B C D E
1
2 JAN FEB MARCH
3 A Y Y
4
5 COMP A JAN FEB MARCH
6 1 2 3
7
8 COMP B JAN FEB MARCH
9 4 2 6
10
11 COMP C JAN FEB MARCH
12 3 1 1
13
14 = (1+2)+(4+2)+(3+1) <------------ sum I want
15
16 = SUMIF(B3:D3,Y,(B6:D6,B9:D9,B12:D12))

sum product sum if conditional HELP!!!
 

Joel,
The double negation is not needed. This is used to convert Boolean
(FALSE/TRUE) to 0/1. Excel makes this conversion whenever a math operation
is performed on a Boolean value. Since you are also multiplying, the double
negation is unnecessary.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Joel" wrote in message
...
You can't use sumif but can use SUM

=SUM(B6:B12)*(--(B3="Y"))+SUM(C6:C12)*--(C3="Y")+SUM(D6:D12)*--(D3="Y")

"laandmc" wrote:

I want to add up specific rows is a condition is satisfied.
whenever there is a Y in the first table I want to add up the
corresponding
values in the 3 tables below
I have tried a sumif sum but that hasn't worked, can anyone please help
me??

A B C D E
1
2 JAN FEB MARCH
3 A Y Y
4
5 COMP A JAN FEB MARCH
6 1 2 3
7
8 COMP B JAN FEB MARCH
9 4 2 6
10
11 COMP C JAN FEB MARCH
12 3 1 1
13
14 = (1+2)+(4+2)+(3+1) <------------ sum I want
15
16 = SUMIF(B3:D3,Y,(B6:D6,B9:D9,B12:D12))