count on a range

[snowbird122]

I need to count how many items are in a certain range, but not in another range. Please help.

[NBVC]

Please be more specific. We need an example please.

[snowbird122]

I have a list of projects in cells A1 through A10. Some project names appear more than once.

I have another list of 3 projects in cells B1 through B3. Each project name in this range in unique.

I need a count of how many cells contain projects that are listed in cells A1 through A10, but are not one of the 3 projects in cells B1 through B5.

For example:
A1 = Project A
A2 = Project B
A3 = Project B
A4 = Project B
A5 = Project B
A6 = Project C
A7 = Project D
A8 = Project E
A9 = Project F
A10 = Project F

B1 = Project A
B2 = Project C
B3 = Project F

The formula should return 6. There are 6 items in the A range that are not in the B range.

How can I do this?

[NBVC]

Try:

=SUMPRODUCT(--ISNA(MATCH(A1:A10,B1:B3,0)))

[snowbird122]

Worked perfect. Thanks so much.