pjfromny
asked on
Reference to Pivot Table returns #REF
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("ChargeAmoun t",'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?
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("ChargeAmoun
Is there anyway to use an IF THEN, so it returns 0 if row 10 does not exist?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER