Hi all

I'm new to this forum and would appreciate some help with a problem I'm having.

The scenario is that I am trying to aggregate survey responses for the year from separate spreadsheets to quarterly and yearly totals. The responses contain not only numerical values but contain, '*', 'N/A' and blank cells depending upon the return. For transparency, I do not want to amend the return in any way.

I am running VLOOKUPS to bring in the 'Percentage Not Recommended' figure, for example, for Jan, Feb and March into 'QTR 1' and working out the overall percentage. So for QTR 1, I'm using the formula =IFERROR(SUM(F3:H3)/COUNTIF(F3:H3,">0"),0) which is the sum of the percentages divided by the number of returns for that quarter, but run into an issue where I get '0' if the return is not a numerical value.

I would like '0' to be returned if the percentage truly is '0' but something like 'no data' if the cells contain no numerical values or are blank. I haven't figured out a way to get this working yet - any assistance would be really appreciated.

Ken