try to find formula problem

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

I've included equal to 22000 in the "over" category

add up all values in a column (column A) for under 22000
=SUMIF(A:A,"<22000",A:A)

add up all values in a column (column A) for EQUAL TO or over 22000
=SUMIF(A:A,">=22000",A:A)

add together the values in column B if the value in Column A is under 22000
=SUMIF(A:A,"<22000",B:B)

add together the values in column B if the value in Column A is EQUAL to or over 22000
=SUMIF(A:A,">=22000",B:B)