your exported summary data resides on a tab named "Summary",
you expect column A to be populated with data, and
no data essentially means nothing appears on the worksheet,
this formula will do the trick:
[font="courier"] =IF((COUNTA(Summary!A:A)+COUNT(Summary!A:A))=0,"No Data Qualified","") /font[/quote]COUNTA counts the non-numeric cells in the column, while COUNT counts the numerics. Combining these in one formula covers all cases so that you can use the same formula for all datasets.
In the end, the text will appear when no data exists, and the text will not appear when data does exist.
Edit to adjust formula slightly.