COUNTIF data messes up during sorting?

[mcintoshmc]

I'm using this formula to count how many openings each manager has:

COUNTIF('Open Reqs'!K:K,Sheet1!$A2)

It works great, but when I sort the data by largest to smallest, all of the date messes up. How can I keep the data during a sort?

 

[Fluff]

Assuming the formula is on sheet1, use
COUNTIF('Open Reqs'!K:K,A2)

 

[mcintoshmc]

Column K is on one sheet, and A2 is on another. The formula works fine. My problem is sorting afterwards.

 

[Fluff]

What sheet is the formula on?