Thanks for providing your assistance and the tutorial. Just to check for understanding, I'd like to explain what I think is happening. This function is giving a summation of all the values in my "Savings" column whenever the corresponding figure in the "Final Cost" column has a value that is not blank. And you were able to identify the non-blank cells by putting in the constraint that it has to be <>"" (which means greater than or less than blank - since there's nothing inside the quotes). Correct, or flawed? That was a crafty way to solve it. I was focused on a way to adjust the subtraction problem (Column A minus Column B), but you illuminated a different approach.



To test my understanding, I tried replicating it using the following formula, but it gives me an error. Any clue why?

=SUMIF(b2:b4,<>"", c2:c4)