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...
try the formula below:
=IF(H2>0,SUM(D2:H2),SUM(D2:I2))
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?