Counting the Number of Different Values in a Column

I have a spreadsheet that includes invoices listed individually. We write checks for multiple invoices at a time. The check number can be listed up to 50 times depending on the number of invoices it pays. I want to know how many checks are in the spreadsheet. In the example below, there are 16 invoices paid by 8 checks. I am looking for a formula that will give me the "8" answer. Thanks much!!!!

PO# Vendor Invoice Check
1223-1215 H 98260786 1
1223-1216 H 98260785 1
1223-1217 H 98260784 1
1223-1218 A CH43026 2
1223-1219 Ha 215355 3
1223-1220 Ha 215356 4
1223-1221 D 213592 5
1223-1222 D 213594 5
1223-1223 ABC 78383091 6
1223-1224 ABC 78361552 6
1223-1225 ABC 78358320 7
1223-1226 ABC 78326017 7
1223-1227 ABC 78308898 7
1223-1228 ABC 78231701 7
1223-1229 ABC 78091880 7
1223-1230 P 319668 8

Use a Pivot Table.

If you still want a formula here are two.

With the understanding that the check numbers are all in column C either

Formula:

Please Login or Register  to view this content.

or array entered

Formula:

Please Login or Register  to view this content.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

	A	B	C
1	PO#	Vendor Invoice	Check
2	1223-1215	H 98260786	1
3	1223-1216	H 98260785	1
4	1223-1217	H 98260784	1
5	1223-1218	A CH43026	2
6	1223-1219	Ha 215355	3
7	1223-1220	Ha 215356	4
8	1223-1221	D 213592	5
9	1223-1222	D 213594	5
10	1223-1223	ABC 78383091	6
11	1223-1224	ABC 78361552	6
12	1223-1225	ABC 78358320	7
13	1223-1226	ABC 78326017	7
14	1223-1227	ABC 78308898	7
15	1223-1228	ABC 78231701	7
16	1223-1229	ABC 78091880	7
17	1223-1230	P 319668	8

In the attached please find the two formulas in D2 and D3.

Did you array enter the second formula? (Ctrl + Shift + Enter)

If you are still having difficulty try uploading the actual workbook you have.