Formula To COUNT IF looking up 2 columns

[jereece]

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

 

[tactps]

You have two options:
1. Pivot table (see help file on this)
2. formulas

To do the formula:
In cell C1, type: Shift A
In cell D1, type: Excellent

In cell E1, use the following formula:
=SUMPRODUCT(--($A$1:$A$10=$C1),--($B$1:$B$10=$D1))
This will count all cells in A1:A10 that are equal to "Shift A" and where the corresponding cells in B1:B10 equal "Excellent".