How to use countif

[leezhihong]

Excel Workbook
	A	B	C
1	NO.	Name	Amount
2	12315	MO	481
3	12321	MO	665
4	42563	MV	273
5	42565	MV	762
6	42574	MV	488
7	42577	MV	780
8	42582	MV	748
9	42589	MV	375
10	42590	MV	644
11	42594	MV	328
13	42596	MV	382
14	42607	MV	654
15	42619	MV	359
16	42623	MV	258
17	42624	MV	316
18	42625	MV	679
19	42626	MV	186
26	83804B	MP	502
27	83805	MP	772
28	83816	MP	460
36	83861	MP	468
40	83866	MP	339
42	83884	MP	734
43	83890	MP	486
44	83909	MP	399
46	83913	MP	751
49
50	Name	How to do	Goal
51	MO		2
52	MV		15
53	MP		9
Sheet1

 

[jeffreybrown]

Try...

=COUNTIF($B$2:$B$46,A51)

and drag down

 

[hiker95]

leezhihong,

Excel Workbook
	A	B	C
1	NO.	Name	Amount
2	12315	MO	481
3	12321	MO	665
4	42563	MV	273
5	42565	MV	762
6	42574	MV	488
7	42577	MV	780
8	42582	MV	748
9	42589	MV	375
10	42590	MV	644
11	42594	MV	328
12	42596	MV	382
13	42607	MV	654
14	42619	MV	359
15	42623	MV	258
16	42624	MV	316
17	42625	MV	679
18	42626	MV	186
19	83804B	MP	502
20	83805	MP	772
21	83816	MP	460
22	83861	MP	468
23	83866	MP	339
24	83884	MP	734
25	83890	MP	486
26	83909	MP	399
27	83913	MP	751
28
29	Name	How to do	Goal
30	MO		2
31	MV		15
32	MP		9
33
Sheet1

The formula in cell C30 copied down:

=COUNTIF($B$2:$B$27,A30)

 

[anandvarma]

try this

Excel Workbook
	A	B	C
1	NO.	Name	Amount
2	12315	MO	481
3	12321	MO	665
4	42563	MV	273
5	42565	MV	762
6	42574	MV	488
7	42577	MV	78
8	42582	MV	748
9	42589	MV	375
10	42590	MV	644
11	42594	MV	328
12	42596	MV	382
13	42607	MV	654
14	42619	MV	359
15	42623	MV	258
16	42624	MV	316
17	42625	MV	679
18	42626	MV	186
19	83804B	MP	502
20	83805	MP	772
21	83816	MP	460
22	83861	MP	468
23	83866	MP	339
24	83884	MP	734
25	83890	MP	486
26	83909	MP	399
27	83913	MP	751
28
29	Name	How to do	Goal
30	MO		2
31	MV		15
32	MP		9
Sheet1

 

[leezhihong]

Excel Workbook
	A	B	C
1	NO.	Name	Amount
2	12315	MO	481
3	12321	MO	665
4	42563	MV	273
5	42565	MV	762
6	42574	MV	488
7	42577	MV	780
8	42582	MV	748
9	42589	MV	375
10	42590	MV	644
11	42594	MV	328
13	42596	MV	382
14	42607	MV	654
15	42619	MV	359
16	42623	MV	258
17	42624	MV	316
18	42625	MV	679
19	42626	MV	186
26	83804B	MP	502
27	83805	MP	772
28	83816	MP	460
36	83861	MP	468
40	83866	MP	339
42	83884	MP	734
43	83890	MP	486
44	83909	MP	399
46	83913	MP	751
49	*	*	*
50	Name	How to do	Goal
51	MO	*	2
52	MV	*	15
53	MP	*	9
Sheet1

The hidden rows isn't count.

 

[Matty]

The hidden rows isn't count.

Could you elaborate?

Matty

 

[hiker95]

leezhihong,


The formula in cell C51 copied down:

=COUNTIF($B$2:$B$46,A51)