Are you using something like:

=sumproduct(--(A2:a100="lmn"),--(B2:B100="C"))

"6pak" wrote:

I can not get the sumproduct function to work properly. I have read a number
of threads and followed the example to a tee, but function will not work.
Here is my problem. I have two colums both on another work sheet. I would
like to count the number of records based on two criterias, one for each
column.
Column one has names of vendors, column two has letters A,B,C
Vendor Part
abc A
abc B
lmn C
xyz B
lmn A

For the criteria Vendor (lmn) and Part (C) I should count only 1 record