How to remove #REF! when when trying to total amounts from Pivot Table

[elpsam78]

I am attaching sample worksheet. It has 4 tabs, Customer, MAY2013, June2013 and YTD2013.

In customers I have placed customer names (in this case made up abbr), The May and June 2013 have numbers from sales orders placed by some these customers. I then make a Pivot table for each month giving me the total $ orders for each customer.

In the YTD2013, I am trying to get all the information from both tables and then put it on a table where I would get a YTD total.

I would like to know what formula/Macro/VB solution would allow me to remove #REF! error when I try to get a YTD total.
I am using GETPIVOTDATA as shown in the YTD2013 sheet.

Your help would be greatly appreciated.

[FDibbins]

Hi and welcome to the forum

Try this variation of what you had. Copy it down and across, you dont need to adjust it for anything - when July2013 gets here, just copy it across...
=IFERROR(GETPIVOTDATA("Total",INDIRECT(LEFT(B$1,FIND(" ",B$1,1)-1)&"2013!$G$1"),"Customer",$A2),"")

[AlKey]

Or try this:

=SUM(IF(ISERROR(B2),0,B2),IF(ISERROR(C2),0,C2))

[FDibbins]

Nice option Alkey

I took the approach of fixing the problem at source (and making the formula more copy-able at the same time)

[AB33]

Within Pivot Table there is an option of removing errors.

[elpsam78]

FDibbins,

Worked really well. Thank you for the input.

[FDibbins]

Happy to help and thanks for the feedback