SUMIF

Copper Contributor

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?

1 Reply

@MaryssaBorden 

=SUMIF(B2:B12,">"&1,C2:C12)

You can try this formula.

sales tax.JPG