sum product sum if conditional HELP!!!

[laandmc]

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(B33,Y,(B66,B99,B1212))

 

[Joel]

You can't use sumif but can use SUM

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

 

[Bernard Liengme]

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