Forum Discussion
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...
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...
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...
Thanks!