Forum Discussion

ragomes1972's avatar
ragomes1972
Copper Contributor
Apr 27, 2021
Solved

Help with Formula

Hi! I have to calculate the average sprint velocity from a table where: - Column A = Sprint # (1 through 28 where 28 is at the top) - Column B = sprint velocity   So based on the above table, th...
excel
  • ragomes1972's avatar
    ragomes1972
    Copper Contributor
    Apr 27, 2021
    Thank you very much, HansVogelaar!
    What if my table with Columns A and B is defined as a Table in Excel, how would I reference to "$B$1" instead?
    I tried transferring the formula but because I actually have it defined as a table, it's not working. Sorry about that...

Resources