Formula Assistance

[Sundance_Kid]

Hey Folks

I have 6 columns each relating to a different tower with a cost for each tower - so columns G to L.

I have above each column a dropdown with either Yes or No.

If I select Yes for 4 columns/towers I want the formula to calculate the combined cost of the 4 towers, if I select Yes for two column/towers, I want the formula to calculate the combined cost of the two towers.

I thought I had it working but it seems, if I select Yes on columns 1,2 & 3, No on column 4 & Yes on column 5, it will only add the columns 1,2 & 3. It is like the formula stops after one of the columns says No.

This was my formula below, but if column J was a No and column K was a Yes along with columns G, H & I, the formula would only add the amounts in column G,H & I and not add the amount in column K.

=IF(G21="Yes",G42+IF(H21="Yes",H42+IF(I21="Yes",I42+IF(J21="Yes",J42+IF(K21="Yes",K42+IF(L21="Yes",L42+IF(M21="Yes",M42),0))))))

Any idea what the issue is?

Thanks

 

[shaowu459]

try this:

Book3
	G	H	I	J	K	L	M	N
18
19
20
21	Yes	No	Yes	No	Yes	No	No	9
22
23
24
25
26
42	1	2	3	4	5	6	7
Sheet1

Cell Formulas
Range	Formula
N21	N21	=SUMIF(G21:M21,"Yes",G42:M42)

 

[Sundance_Kid]

Thank you shawou459, that worked perfectly and super easy.

Many thanks

 

[shaowu459]

Thank you shawou459, that worked perfectly and super easy.

Many thanks

You are welcome~