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...
Sorry, that didn't work. Let me try to explain this better. I want a formula for cell C2 (Total Score) that does this:
IF H2>0, then C2 =SUM(D2:H2).
If H2<1, then C2 =SUM(D2,F2,G2,I2).
Hello,
I'm sorry but are you aware that IF H2=0.5 ( or 0.2, ...) the two conditions are accepted ?
they intersect!