Hi Everyone,
From the below information, I would like to sum the last 'n' values based from the TE columns (K and R) depending on which team I select in another cell.
For example:
I select the team "NO" and want to sum up the last two values --- the formula would sum up 25.46 from Column R and 19.7 from Column K.
Does anyone know how to do this?
I really hope I'm making my request clear.
Cheers,
Chris
From the below information, I would like to sum the last 'n' values based from the TE columns (K and R) depending on which team I select in another cell.
For example:
I select the team "NO" and want to sum up the last two values --- the formula would sum up 25.46 from Column R and 19.7 from Column K.
Does anyone know how to do this?
I really hope I'm making my request clear.
Cheers,
Chris