I am working to count items in a spreed sheet that has several fields on it.
I want to count how many items have an item number of "4016" and a price of
"100". Both fields must equal true for it to count them.

Thank you,

Charles

=SUMPRODUCT(--(B2:B100=4016),--(C2:C100=100))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Charles" wrote in message
...
I am working to count items in a spreed sheet that has several fields on
it.
I want to count how many items have an item number of "4016" and a price
of
"100". Both fields must equal true for it to count them.

Thank you,

Charles