Am I using COUNTIF correctly?

[charlesstricklin]

I'm a little puzzled, I'm sure because it's that I'm not understanding something correctly. Say that I've made a pivot table from the following data:

Month	Company
January	Company A
January	Company B
February	Company A
February	Company B
February	Company A
February	Company B
February	Company C
February	Company A
February	Company B
March	Company A
March	Company B
March	Company B
March	Company B
March	Company C
March	Company B
April	Company A
April	Company B
April	Company A
April	Company A
April	Company B
April	Company C
April	Company A
April	Company B
May	Company A

How do I use COUNTIF to count how many of Company B is in May? Or how do I count how many of Company C there are when I've chosen April only in my pivot table? Or do I use something other than COUNTIF? I'm confused. Do I use COUNIFS instead? BTW I'm using Windows Excel 2010, if that matters.

 

[Ezguy4u]

charles Let's get the ball rolling. Here is my solution to your problem. Now maybe this doesn't solve all your problems but we have to start somewhere. So let the discussion begin

24-02-04.xlsx
	A	B	C	D	E	F
1	Month	Company
2	January	Company A
3	January	Company B		Company A		4
4	February	Company A		April
5	February	Company B
6	February	Company A
7	February	Company B		January
8	February	Company C		February
9	February	Company A		March
10	February	Company B		April
11	March	Company A		May
12	March	Company B
13	March	Company B
14	March	Company B
15	March	Company C
16	March	Company B
17	April	Company A
18	April	Company B
19	April	Company A
20	April	Company A
21	April	Company B
22	April	Company C
23	April	Company A
24	April	Company B
25	May	Company A
Data

Cell Formulas
Range	Formula
F3	F3	=COUNTIFS(B2:B25,D3,A2:A25,D4)

Cells with Data Validation
Cell	Allow	Criteria
D3	List	=$B$20:$B$22
D4	List	=$D$7:$D$11

 

[AhoyNC]

You should be able to get your counts and filter your data in the pivot table without COUNTIF.

Set your pivot table up like this.
Then you can use the drop down arrows in the column and rows to filter by companies and months.

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Month	Company
2	January	Company A
3	January	Company B			Count of Company	Column Labels
4	February	Company A			Row Labels	January	February	March	April	May	Grand Total
5	February	Company B			Company A	1	3	1	4	1	10
6	February	Company A			Company B	1	3	4	3		11
7	February	Company B			Company C		1	1	1		3
8	February	Company C			Grand Total	2	7	6	8	1	24
9	February	Company A
10	February	Company B
11	March	Company A
12	March	Company B
13	March	Company B
14	March	Company B
15	March	Company C
16	March	Company B
17	April	Company A
18	April	Company B
19	April	Company A
20	April	Company A
21	April	Company B
22	April	Company C
23	April	Company A
24	April	Company B
25	May	Company A
Sheet2