Hi,

This is the formula I'm currently using - =IFERROR(1/(1/SUMIF(Table1[Date],G107,LISTINGS!D:D)),"Figure not obtained"). How would I get it to display no results as N/A?

Ben