It is, the formula is now - =IFERROR(1/(1/SUMIF(Table1[Date],G37,LISTINGS!D:D)),"#n/a")

This is in the table that the pivot table is linked to.

Ben