Forum Discussion
Solved
SUMIFS with INDIRECT
Hi, I am trying to reference a a column in a table using sumifs indirect reference. I was able to use this formula =SUMIFS(INDIRECT("'"&F$4&"'!$K:$K"),INDIRECT("'"&F$4&"'!$J:$J"),$E5) but the data...
BenjoBenjo The file link requires a log-in so I can't access it. Attaching another file with three years and the same formula copied across. It works as intended.
check that file i hope help you how to do it
you can add sheets and make table name same way and will be report dynamic
- Hi abdelaziz, thank you so much. The issue is solved. I did not lock the cell F4. Really appreciate your help
- you are welcome bro
