Excel formula help

Highlighted
Occasional Contributor

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 shot attached.

21 Replies
Highlighted

Ahmad, you rock!! Thank you so much. Wow, that's so elegantly simple but I could not figure it out for myself. 

Highlighted
you are welcome