May 10 2022 12:43 PM
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!
May 10 2022 12:54 PM
SolutionMay 10 2022 01:00 PM
May 10 2022 01:06 PM
May 10 2022 12:54 PM
SolutionTry pointing to the ranges when you create the formula. It should work: