Good Morning,
I am looking to create a little table which basically has 3 cells of numbers below what i want to be able to do is is if any cell in column G:G has a 1 in it the formula takes the i2 number and subtracts the number in column D:D where it found the 1.
So for example there is a 1 in G2 so the formula would take 2201 and subtract the corresponding number in D2 and so on if the 1 was in G4 if would take the corresponding number in D4 however i would also like it to be able to see if there is a 1 in G2 and G3 and G4 it knows to take I2 and subtract all the corresponding numbers in the Column D2 etc can this be done if so appreciate any help
I am looking to create a little table which basically has 3 cells of numbers below what i want to be able to do is is if any cell in column G:G has a 1 in it the formula takes the i2 number and subtracts the number in column D:D where it found the 1.
So for example there is a 1 in G2 so the formula would take 2201 and subtract the corresponding number in D2 and so on if the 1 was in G4 if would take the corresponding number in D4 however i would also like it to be able to see if there is a 1 in G2 and G3 and G4 it knows to take I2 and subtract all the corresponding numbers in the Column D2 etc can this be done if so appreciate any help
H | i | j | k |
1 | 2201 | =IF(G:G=1,I2-D:D) | |
2 | 445 | ||
3 | 1452 | ||
18.3 |