Referring to 3 variables with GETPIVOTDATA

[Darkcloud617]

Hello,

I probably have a silly question- I tried to search the forum and could not find something similar so apologies if its exists. Anyway, I am trying to get this formula to work but it keeps returning #REF. Its referring to the month as the final variable so I am stumped. It works until I include the month in the formula. I am referring to other cells but even if I type in "October" into H7 it returns the same #REF. Any help would be greatly appreciated.

Please Login or Register  to view this content.

[Darkcloud617]

I was able to figure this out. Silly me, I was referring to the total section instead of the month section. Excel could not refer to the month because it didnt exist.