Thanks a million!! That help-sheet makes sense and drives the point home. Sorry about the name thing. I saw your "handle" that says "je suis Charlie" (I am Charlie) and figured that was your name. Yeah, I know it didn't say, "Je m'appelle Charlie" (my name is Charlie). I guess I was a few days out of the loop on that being a slogan related to recent international events. Thanks again for everything, Herbert...LOL... Just Kidding... Thanks, Pecoflyer...

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)

Np with Charlie ( for me, allas not for those who were slaughtered). And yes, you are right to use the SUMIF function. I always seem to forget that it exists

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks to both of you!! I had been researching for a week before I joined this site, but now I know why I couldn't find anything: because the SUMPRODUCT used in this fashion is a bit of a workaround. I tried the SUMIF just to test my understanding and apply a similar function, but the SUMPRODUCT fits the bill in this case because it treats a blank cell differently than a cell that has zero. In my real-life scenario, there is a difference because a blank cell should be ignored (as I have not received data for those), whereas a cell with zero should be computed because that's the true value. So because of you two, I have two additional tools in my belt to use for future spreadsheets!!!