Hello,
I have a reference lookup to a pivot table that uses the following formula
=GETPIVOTDATA("Price Used",'IBE All'!$A$3,"Month Number",C$1)
The lookup is working good except for the months where there is no value present. For those months I am getting the #REF! error. When I go and try to sum up the total I am getting the #REF! error despite there being numbers in the fields. I am just using this formula to sum =SUM(C2:N2)
Does anyone know why I would be getting the #REF! error when just summing values? Is it due to that pivot table lookup?
Thank you in advance!
Andrew
I have a reference lookup to a pivot table that uses the following formula
=GETPIVOTDATA("Price Used",'IBE All'!$A$3,"Month Number",C$1)
The lookup is working good except for the months where there is no value present. For those months I am getting the #REF! error. When I go and try to sum up the total I am getting the #REF! error despite there being numbers in the fields. I am just using this formula to sum =SUM(C2:N2)
Does anyone know why I would be getting the #REF! error when just summing values? Is it due to that pivot table lookup?
Thank you in advance!
Andrew