I have DEALER MAP Quantity columns in Google Sheets On the MAP column I am having my Grand total which is the SUM of my MAP column. The Quantity column is having 0s which means there is no Product selected.
I want to show the Grand Total as 0 under MAP but Not 0 when any number more than 0 is added into Quantity.
The 10% is the row for finding TAX.The fomulas are here for
TAX =(D3E3+D5E5+D6E6+D7E7+D8E8+D9E9+D10E10+D11E11+D12E12+D13E13+D14E14+D15E15)*D20
For The Grand Total =SUM(D3:D15,E20)
1231.PNG
Bookmarks