Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 435
- Office Version
- 365
- Platform
- Windows
I have a named range "PC" in a cell in workbook where the formula is going looking up the sum range and the criteria range in another workbook. I have the Criteria in Cell C17 of the workbook where the formula is. I have the formula below which returns the word VALUE and I cannot see why. I broke it up to see if each part was working and I think it all is.
Any help on what I am doing wrong would be really helpful.
Thanks
=SUMIFS(INDIRECT("'"&"["&"Breakfast Foods Combined Raw Data.xlsx"&"]"&"Performance Data'!"&$C$15),'[Breakfast Foods Combined Raw Data.xlsx]Performance Data'!$A$2:$A$100000,"="&C17)
Any help on what I am doing wrong would be really helpful.
Thanks
=SUMIFS(INDIRECT("'"&"["&"Breakfast Foods Combined Raw Data.xlsx"&"]"&"Performance Data'!"&$C$15),'[Breakfast Foods Combined Raw Data.xlsx]Performance Data'!$A$2:$A$100000,"="&C17)