I have a spreadsheet with 2 collumns as below.
Column A = Group
-Shift A
-Shift B
-Shift C
-Shift D
-Shift E
-Staff
Column B - Survey Resonse
-Excellent
-Average
-Needs Improvement
On a seperate tab, I want to list each group with a count for each survey resoponse. For example, I need a formula that will Count if Column A = Shift A and Column B = Excellent. In another cell a formula to count If Column A = Shift A and Column B = Average and so on.
If someone can just get me started, I can modify for each cell.
I appreciate your help.
Jim
Column A = Group
-Shift A
-Shift B
-Shift C
-Shift D
-Shift E
-Staff
Column B - Survey Resonse
-Excellent
-Average
-Needs Improvement
On a seperate tab, I want to list each group with a count for each survey resoponse. For example, I need a formula that will Count if Column A = Shift A and Column B = Excellent. In another cell a formula to count If Column A = Shift A and Column B = Average and so on.
If someone can just get me started, I can modify for each cell.
I appreciate your help.
Jim