sum product sum if conditional HELP!!!


L

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(B3:D3,Y,(B6:D6,B9:D9,B12:D12))
 
Ad

Advertisements

J

Joel

You can't use sumif but can use SUM

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

Advertisements

B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top