SOLVED

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

Copper Contributor

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:H8470-F2:F8470))

 

For some reason the formula isn't always updating. Of note is that there are dates in the two columns.

 

Would it help if I used the Table Name and Column Names? I can't seem to get it to work like this...

 

=AVERAGE(IF(tblCOMPLETE[Date BPC003F Recieved]<>"",tblCOMPLETE[Completed Date]-tblCOMPLETE[Date BPC003F Recieved]))

 

Is it a problem to have spaces in the column names? I'm not sure what I'm doing wrong here. Can someone see the problem? Thanks! 

 

 

3 Replies
best response confirmed by Marcus_Booth (Copper Contributor)
Solution

@Marcus_Booth 

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

S1421.png

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.
So sorry! Someone had misspelled the table name. Working great now! Thank you!!!
1 best response

Accepted Solutions
best response confirmed by Marcus_Booth (Copper Contributor)
Solution

@Marcus_Booth 

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

S1421.png

View solution in original post