Ben McClave presented the following explanation :
Hello,

After looking at your sheet, I think that you may be referencing the wrong
CriteriaRange (F2:F2000 should be E2:E2000). This formula worked for me in
cell G2:

=CountFromColumn(B2:B2000,E2:E2000,"Diagnostic Testing","Refurb Actuator")

Using your test sheet the formula returned 69. When I checked the result
using a pivottable (to filter the list to just the parts meeting the two
criteria), it also returned 69 unique part numbers.

Hope this helps,

Ben

It might be a good idea to use a defined name for the range to ref
since inserting/deleting cols will cause the formulas to change the
ref. This might not be what's desired...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion