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