Use the SUMPRODUCT function.

=SUMPRODUCT(--(A1:A10=1),--(B1:B10="y"))

This will count the number of items with 1 in A1:A10 and 'y' in
B1:B10.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Boulder257"
wrote
in message
...

Okay, this may be a tough one:

Let's say in Column A I have different products (1,2,3,etc)
In Column B I have whether that product has been sold ("Y" or
"N")
I need to count how many of product 1 I have sold.

How can I do this without adding any additional columns?


--
Boulder257
------------------------------------------------------------------------
Boulder257's Profile:
http://www.excelforum.com/member.php...o&userid=20053
View this thread:
http://www.excelforum.com/showthread...hreadid=505320