Hi Everyone,

I have a quote sheet at work that is truly the bane of my existence.

In C11 to C18 I have Quantities
In D11 to D18 I have Prices
In G11 to G18 I have Totals
So what I have done is C11*D11= Total.

The issue that I have is that if any cells from C11 to C18 are 0 then I want the Sum total (Cell G21) =G11:G18 to show "Add Value".

The problem is two fold =IF(C11=0,"Add Value") works fine for one line item but lets argue that C11 = 0 and C12 = 1. How do I then get my Total in G21 to disregard C11 and continue the calculation from G12:G18 to get a total?

I hope anyone can help I need this done urgently and my boss is getting very uptight about it.

Thanks
Steve