Reference to Pivot Table returns #REF
Posted on 2013-12-17
I have Excel worksheets connected to Access tables, which create Pivot Tables. The results are grouped by month, and I have a cover sheet which summarizes the data from multiple worksheets.
There is a summary line for each month, but if the pivot table does not have a line for that month, the it returns #REF, and messes up any calculation using that cell.
For example: if there is no month 10 (October) =GETPIVOTDATA("ChargeAmount",'camper charges'!$A$1,"ChargeDate",10) returns #REF
Is there anyway to use an IF THEN, so it returns 0 if row 10 does not exist?