Forum Discussion
Using a value in a cell as a sheet name in a function
Hi, I have a situation where i want to use a value in a cell (Cost Code - column F) as a sheet number in my function. In this example, i have sum + filter function where i am trying to sum all i...
Hi Jimmyolo96
You have to use the INDIRECT function:
in E6 or wherever you want:
=SUM( FILTER( INDIRECT("'" & F6 & "'! H6:H15"), INDIRECT("'" & F6 & "'! A6:A15") = A6 ) )
Hi Jimmyolo96
You have to use the INDIRECT function:
in E6 or wherever you want:
=SUM(
FILTER(
INDIRECT("'" & F6 & "'! H6:H15"),
INDIRECT("'" & F6 & "'! A6:A15") = A6
)
)
it works! thank you so much!
- You're welcome & Thanks for providing feedback
