Countifs or a pivot
 

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

Countifs or a pivot
 

Hi Paul,

Am Tue, 11 Mar 2014 08:27:06 -0700 (PDT) schrieb 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 a look:
https://onedrive.live.com/?cid=9378A...121822A3%21326
for workbook "CountIf_Paul"


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2