Display Result of a Formula OR Specific Text

I'm putting together a costing spreadsheet for a client that automatically adds totals to an invoice that will be sent to their clients. I'd like to be able to have a formula that either displays the result of a sum OR displays "No Charge" if the total is zero.

I have an example spreadsheet showing what I mean, but here's a screenshot showing what I'm talking about as well.

Screenshot 2021-01-28 135227.png

I have my "Zones" in column A and the total cost for each zone in column B. My Invoice information displays the Zone Name in Column D and the total cost searching for specific zone names in column E.

Column E is using this formula:

Please Login or Register  to view this content.

I'm doing it like this because my actual invoice has 50 zones, each with 12 "fixes" available. So I'd like to be able to add everything that says "Zone 1 Fix 1" together whether that be 1 instance or 12.

When the price displays as $0, I'd like it to change the text to say "No Charge", but if the price is more than $0.00, it should display the total for everything specified in the SUMIF. So, we can see that E2 has a total of $65, but if the SUMIF for "Zone 1 Fix 1" came up with $0, it would display "No Charge" instead of $0.00.

I've been bashing my head against this using all manners of SUMIF and IF/OR and even conditional formatting but nothing seems to work the way I'd like it to.

One of the requirements is that it says "No Charge" instead of $0.00 and that the spreadsheet be reusable, so they can continue to edit the prices in column B so column E either displays the price or the specified text.

Formula:

Please Login or Register  to view this content.

Or this

Formula:

Please Login or Register  to view this content.