I have a spreadsheet of customers, with columns for whether they are wholesale or retail, their total cost for each order, the cost of items, cost of shipping, and any applicable sales tax cost. I did a SUMIF function to get total sales without sales tax, but I want to get Excel to copy rows with sales tax entries >0 into new rows at the bottom of the spreadsheet or even to a different spreadsheet. Alternatively, I'd like to be able to sum the column for the cost of items only for those sales which were subject to sales tax. I'm trying to use multiple criteria for the SUMIF function and it's just not working!. Can anyone help?
Solved by M. B. in 24 mins