Countifs or a pivot

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top