This is my current formula:

=SUM(IF(ISERROR(GETPIVOTDATA("Premix 1",$A$3,"Formula #",175100,"Group
#",Sheet1!C2)),0,(GETPIVOTDATA("Premix 1",$A$3,"Formula #",175100,"Group
#",Sheet1!C2))),IF(ISERROR(GETPIVOTDATA("Premix 1",$A$3,"Formula
#",1575100,"Group #",Sheet1!C2)),0,(GETPIVOTDATA("Premix 1",$A$3,"Formula
#",1575100,"Group #",Sheet1!C2))),IF(ISERROR(GETPIVOTDATA("Premix
1",$A$3,"Formula #",275100,"Group #",Sheet1!C2)),0,(GETPIVOTDATA("Premix
1",$A$3,"Formula #",275100,"Group
#",Sheet1!C2))),IF(ISERROR(GETPIVOTDATA("Premix 1",$A$3,"Formula
#",2575100,"Group #",Sheet1!C2)),0,(GETPIVOTDATA("Premix 1",$A$3,"Formula
#",2575100,"Group #",Sheet1!C2))),IF(ISERROR(GETPIVOTDATA("Premix
1",$A$3,"Formula #",375100,"Group #",Sheet1!C2)),0,(GETPIVOTDATA("Premix
1",$A$3,"Formula #",375100,"Group
#",Sheet1!C2))),IF(ISERROR(GETPIVOTDATA("Premix 1",$A$3,"Formula
#",3575100,"Group #",Sheet1!C2)),0,(GETPIVOTDATA("Premix 1",$A$3,"Formula
#",3575100,"Group #",Sheet1!C2))),IF(ISERROR(GETPIVOTDATA("Premix
1",$A$3,"Formula #",475100,"Group #",Sheet1!C2)),0,(GETPIVOTDATA("Premix
1",$A$3,"Formula #",475100,"Group #",Sheet1!C2))))

I have at least 7 different Formula # possibilities that can occur in my
pivot table for each Group #. Is there any way to create a formula using
wildcards to recognize the Formula # using the last five digits of the
formula #? Every time I try to insert the wildcard I get an error message.
I haven't been able to get it to work with either the "?" or "*" characters.