Forum Discussion

prr924's avatar
prr924
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
prr924's avatar
prr924
Copper Contributor
Mar 12, 2019

Hmm...this seems to work!!! Wow, thank you so much!!

ahmad ali's avatar
ahmad ali
Brass Contributor
Mar 12, 2019

prr924  You are welcome 

  • prr924's avatar
    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. 

    • ahmad ali's avatar
      ahmad ali
      Brass Contributor
      Mar 12, 2019

      try the formula below:

       

      =IF(H2>0,SUM(D2:H2),SUM(D2:I2))

       

      • prr924's avatar
        prr924
        Copper Contributor
        Mar 12, 2019

        If I use this formula 

        =IF(H2>0,SUM(D2:H2),SUM(D2:I2))

        that gives a total score of 100 for all three rows. 

         

        This is an assignment that has two options. Students can either write a paper on a finished research project (option 1: scored in column H) or they can write a paper presenting 2 hypotheses and a research plan (option 2: scored in columns J-L which are then summed in column I). They will have a score in column H or column I, never both. 

         

        All students, regardless of which option they choose, will have some points in columns D-G that need to be included in their total score. 

         

        Maybe this just can't be done? 

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Mar 12, 2019

      I skipped your latest sample, it looks like you sum D2:I2 independently of H2. What is your exact logic?

Resources