I'm having problems with 2010 tables. My table has rows each with names i column, total points by sum 1 column, 26 columns of competition places 1st, 2nd etc, 12 columns which use COUNTIFto establish THE number of 1st, 2nd etc for tie-breaking on equal totals, 26 columns which use HLOOKUP to establish points awarded according to position in competition and type of competition.
When I insert a row in the table (using right click insert below or tab from last cell in table) the COUNTIF ranges are incorrect in the new row e.g. $C9:$AB9 becomes $C10:$AB11 instead of $C10:$AB10. Am I being dull or is this a bug?