I am very happy using Excel 2007 new table features.

1) I have a table with this header:

Name-Surname-Code-January-February...

2) I have this sumif formula to sum month values for each name

=SUM.IF(MyTable[Name];$G4;MyTable[January])

3) When I copy my formula to the right it shows

=SUM.IF(MyTable[Surname];$G4;MyTable[February])


The problem is that I canīt let the [Name] part fixed. I tried with [$Name$] thinking about excel 2003 logic, but I didnīt work. I need to copy my formula to the left, leting the [Name] fixed and allowing [Month] to change...

Do you know how to do it?

Thanks a lot