Forum Discussion

Copper Contributor

Mar 12, 2019

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

excel

Excel on Mac

Formulas and Functions

ahmad ali

Brass Contributor

Mar 12, 2019

in this case you can try this: =IF(H2>0,SUM(D2:H2),D2+F2+G2+I2)

prr924
Copper Contributor
Mar 12, 2019
Hmm...this seems to work!!! Wow, thank you so much!!
- ahmad ali
  Brass Contributor
  Mar 12, 2019
  prr924 You are welcome
  - prr924
    Copper Contributor
    Mar 12, 2019
    Oops, I spoke too soon. It still doesn't work. See screenshot attached. Test Student Option 2 should be a 100. The next row down is a real world (not perfect) score and should be an 82 but it's scoring out at 74.