Forum Discussion
Excel formula help
I'd like to create a formula that either sums columns D2 through H2 OR D2-G2 plus I2. In other words, for the second option I want it to skip H2. Can this be done and if so how do I do it? Screen sho...
I know this stuff is way beyond my basic skill set, but why would I want to subtract the value from E2?
Since based on your requirement if H2=0 you sum
prr924 wrote:
then C2 =SUM(D2,F2,G2,I2).
other words all from D2 to I2 but E2 and H2.
H2 is zero under this condition, thus you need to substruct only E2 from full sum.