Feb 25 2021 02:18 PM
Thanks in advance!
I have a spreadsheet with two sheets. This spreadsheet collects customer survey satisfaction scores.
Sheet 1 has a mix of variables in column A that are IT, HR, Payroll, and Travel. There are 7 questions scored 0-10 across 7 columns. There are thousands of rows and a huge amount of columns, I only need to calculate 7 columns. I created a sample attachment.
Sheet 2 has 2 columns. Column A has 4 cells: IT, HR, Payroll, and Travel. I need column B to show HOW MANY TIMES each of those resulted in at least 4 of the 7 questions scored below 4. Please see my attached example. I have no idea how to use macros and want to use formulas for this.
Please help :(
Feb 25 2021 03:24 PM
You can use formulas for a helper column such as the one you used on the first sheet.
You can then use COUNTIFS to get the counts you need.
See the attached workbook. You'll have to adjust the ranges for your real workbook of course.
(Your example counts a score of 4 and below, instead of below 4)
Feb 26 2021 03:45 PM
@Hans Vogelaar You are the best.