Forum Discussion

Marcus_Booth's avatar
Marcus_Booth
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...
  • HansVogelaar's avatar
    May 10, 2022

    Marcus_Booth 

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

Resources