Sundance_Kid
Board Regular
- Joined
- Sep 2, 2017
- Messages
- 129
- Office Version
- 365
- Platform
- Windows
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
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