Forum Discussion

Iron Contributor

May 10, 2022

Solved

Trying to Reference Table Columns in a Formula using Table/Column Name

Working with Excel Online version... Office 365 I'm using the following formula in a cell on the same worksheet as the table I'm trying to reference in the formula... =AVERAGE(IF(F2:F8470<>"",H2...

excel

Excel for web

Formulas and Functions

office 365

HansVogelaar
May 10, 2022
Marcus_Booth

Try pointing to the ranges when you create the formula. It should work:

HansVogelaar

MVP

May 10, 2022

Marcus_Booth

Try pointing to the ranges when you create the formula. It should work:

Marcus_Booth
Iron Contributor
May 10, 2022
So sorry! Someone had misspelled the table name. Working great now! Thank you!!!
Marcus_Booth
Iron Contributor
May 10, 2022
When I paste this very formula into the cell, Excel puts a little hash before the = sign. It comes back when I delete it and the formula is not active. I'm using the Web app. I don't get any error messages. It's as if it thinks I'm just typing text.