Countif with multiple criteria and calculations

I worked this out as follows. Assume the 1% increase per year. Solve the compound interest formula A = P(1+r/n)^nt for A (Amount) which, given n=1, yields P = A/(1+r)^t That yields the initial salary for the employees. The formula to do that is in column F and reads:

Formula:

=ROUND(C2/(1+J$2)^E2,0)

Column G then calculates the amount of annual increase using the formula:

Formula:

=ROUND((C2-F2)/E2,2)

The formula in column H then ranks employees with similar job titles and grades based on annual increase using the formula:

Formula:

=SUMPRODUCT((A$2:A$12=A2)*(B$2:B$12=B2)*(G$2:G$12>G2))

The ranking ends up showing the number of employees with the same job tile and grade that are getting a larger annual increase, which if I understand correctly is what you want to determine.
Let me know if you have any questions.