Dear Experts,
I have a little thing here. For you, I'm sure it's a easy thing, but I have not been able to manage what I want to do.
I have attached a screenshot of my spreadsheet.
What I want to archive is not to show any entry in cell D65:N65, when its empty or "0"
In the subtotal cells I have used this formula:
=IF(D49:D51=0;"";PRODUCT(LEFT(D49;FIND(" ";D49)-1)*1)*D50*D51)
As I want to multiply cell numbers including Text.
But how do I archive to Sum up the "Subtotals" D65:N65 without getting an #Value Error and not show the entry if it is "0"
I appreciate your help!
Best wishes from Berlin
Bookmarks