Countifs or a pivot

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Hi, I have a table of data and need to count how many exemptions have been used each month, ie for the month of Jan Section 10 = 3, Section 15 = 4etc.

Have tried using a pivot and countifs but am now totally stuck...Please help

Request Months Exemption1 Exemption2 Exemption3 Exemption4
1 1. Jan Section 8 Section 9 Section 10 Section 20
2 1. Jan Section 9 Section 20 Section 21
3 1. Jan Section 2 Section 3
4 1. Jan Section 10 Section 20 Section 30 Section 40
5 1. Jan Section 10 Section 15 Section 30
6 1. Jan Section 15
7 1. Jan Section 15 Section 20 Section 30
8 1. Jan Section 15 Section 40
9 2. Feb Section 8
10 2. Feb Section 15 Section 30 Section 40
11 2. Feb Section 9 Section 10 Section 30 Section 40
12 3. March Section 10
13 3. March Section 10
14 3. March Section 9 Section 10 Section 30 Section 35
15 3. March Section 10 Section 20 Section 30 Section 40
16 3. March Section 15 Section 20
17 3. March Section 15 Section 20
 
Back
Top