OFFSET COUNTA Named ranges in a table

Dear all,

I'd like to produce a dynamic named range called "Margin" (highlighted in green in the enclosed file) that will change as more columns are added to a table.

The named range would be used in a "Top 10" table calculation, using the AGGREGATE function. The formula finds highest to lowest margin values and ranks them.

I have tried to use the formula OFFSET(C11,0,0,1,COUNTA(11:11)) in the name manager, but I get odd results.

Is there another way to define the named range along row 11 as I add more jobs to the table?

I enclosed an example file.COUNTA and OFFSET.xlsx

Thanks

Thanks for your comments.

I seem to have solved this issue with the following adjustment:

=OFFSET(C11,,,,COUNTA(11:11))

It seems ignoring rows, columns and height (i.e. ,,,,) completes the formula. However, I'm not sure why leaving them blank would work while 0,0,1 does not.

Regards.