Oct 20 2022 11:44 AM
I am developing a sales tax worksheet for a client. In column a we have total sales, column b we have what the sales tax would be for the sales, and column c we have the net amount (col a - col b). Now I am looking for how I would type a sumif formula to only include certain sales items because only certain items require sales tax. So how would I get a sum of column c, but only to include values that have a corresponding value >1 in column b?