=SUMIF($AA:$AA,$A3,$Z:$Z)

this is exactly the same formula I have used on an excel 2003 sheet for
years. However it does not work when I open the same worksheet in excel 2007.
It just returns 0.
Cannot work out why.
I've tried formatting the cells differently, using tables, names etc what am
I doing wrong?