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))