I’m creating a spreadsheet to help keep logs of jobs I do daily and weekly. I need a formula to add rows in a column, then subtract a certain amount as long as the amount is over a certain amount..

Example;

I have 4 or 5 rows that the amounts are over $51.00

I need to add those rows and then subtract $14.00 from each

unless the amount is under $51.00 then I need to subtract $6.00

By: Kelly Kopke