BrianExcel
Well-known Member
- Joined
- Apr 21, 2010
- Messages
- 975
I need to find and assign the average of a specific column within a table called "Sum7EditsTable" so I can then pass that into a text box.
I have the following formula, which is a copycat of some other calculations I am doing to generate a graph, but for some reason this just returns a blank value.
How do I get the average of a table column using the header as opposed to doing a full-on rows.count formula to get the last cell, etc.?
I have the following formula, which is a copycat of some other calculations I am doing to generate a graph, but for some reason this just returns a blank value.
How do I get the average of a table column using the header as opposed to doing a full-on rows.count formula to get the last cell, etc.?
VBA Code:
ActiveWorkbook.Names.Add Name:="sAverage", RefersToR1C1:="=AVERAGE(Sum7EditsTable[[#All],[Percent Edit]])"