I see . Then try the following to extract the total savings : Adapt the ranges to your needs

__________________
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 a million, Charlie!! It worked! Do you have a link that explains how and why this works? That way, I'll know how to apply it to other situations. I don't recall seeing many of those characters in any of the other formulas I tried while researching this. Maybe that's why none of them worked. This works perfectly, because when '0' is entered, I want it to do that calculation (which it does!) and it ignores the blank cells (which it should!).

How does it know to differentiate between 'blank' and zero?