Forum Discussion

BenjoBenjo's avatar
BenjoBenjo
Copper Contributor
Oct 24, 2023
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...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Oct 25, 2023

    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.

BenjoBenjo's avatar
BenjoBenjo
Copper Contributor
Oct 25, 2023
Hi abdelaziz, thank you so much. The issue is solved. I did not lock the cell F4. Really appreciate your help
abdelazizallam's avatar
abdelazizallam
Copper Contributor
Oct 25, 2023
you are welcome bro

Resources