Good evening everyone
I have a table of prices for which I need to calculate the AVERAGE price for. This table contains 4 different columns (including a date column, others are prices. This table is a named range of cells, named prices. I am able to work out average price using the cell ranges but not using the named range.
I am entering the average answer into another table (column 3)
My formula starts =AVERAGE(
Any help would be greatly appreciated, thanks
Bookmarks