I have been presented with two tasks that need to be done in an Excell spread sheet. Both seem very similar so I think I can put them both here.

Situation 1
I need a formula to add up all values in a column (column A) for over or under 22000. I will put the over in one cell and the under in another. The column has values in it all the way from 10 to 100000 and this will determine a discount.

Situation 2
Similar to situation 1, I need to have a formula that will add together the values in column B if the value in Column A is over or under 22000. I will put the over in one cell and the under in another. This will used in determining a Tax.

I have tried to combine a sum and an if statment and I have also looked at a count if statement. Please help.


Thank You