I have an Excel spreadsheet with several pivot table
Then I have a sheet which collects data from the pivit table
The issue I have is that if the value does not appear on the pivot table I get "
#REF! and then it will not give me a total
the formula is
=+GETPIVOTDATA("Total Hrs Cost",'By Month'!$A$1,"Month","MAR")
Can I modify this so that if the value does not appear on the pivot table it defaults to 0
Then I should be able to total the values