I have a scenario where I'm trying to consolidate survey responses from individual monthly spreadsheets to quarters. I also have the number of responses for each month in a separate spreadsheet.
I'm using a SUMPRODUCT(VLOOKUP function to pull through the total responses for the quarter but need some help combining this with an IF function to return "No data" if the values are less than 6 as the sample would be too small.
Following that, I'm trying to calculate the response rate of people 'Extremely likely to recommend', 'Likely to recommend', 'Neither', 'Unlikely' and 'Extremely unlikely' by summing the total number of responses in each category by the number for that quarter. With this one I'm running into either '0' being displayed when there are text characters in the original data or '#DIV/0!' if the value is 0. I would like this to be either "No match" if the data is blank or is "'*", or to be '0' if the there are no responses. I cannot amend the original data for transparency.
Any help would really be appreciated, thanks.
Bookmarks