I went back to the post and answer that you gave me on my Nov 8th post.
I was trying to use a cell that had a game counter in it using Countif.
I wanted to be able to average any desired number of the last (n) cells in a column
You supplied the following formula:
=AVERAGE(INDIRECT("J" & A4-B5 & ":J" & A4+C5))
In a another post you suggested changing my WS's to tables and then be able to use Counta and Offset to achieve the same result which would be to average the last (n) cells in a column. That formula was:
Am I reading this correctly that the first formula would be for use on a range and the second would be on a table and both would provide the same result...average the last (n) cells in a column? If so is there any virtue to using one format vs another?
Does changing all the WS's in a WB to tables from ranges change anything else. Will all the cross WS formulas still work?