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...
could you please clarify, if
H2=0.5
H2=1
what it'll be in such cases
H2 will always be a whole number. If H2=1 (or greater), then C2 should =SUM(D2:H2).