counting in 2003 - sorry if this is an easy one!

Hi all,

To me, this seems to be an ultra-easy question, but I can't find a workable solution through Google.
I have two columns with data, something like this:
| customer | Y |
| vendor | N |
| customer | N |
| customer | Y |
I just want to count how many of each combination I have. So I have a separate table with how many customer Y, how many customer N, etc. etc.

I seem to find this ought to be COUNTIFS(A:A, "customer", B:B, "Y") to find how many Customer Y. But I'm using Excel 2003. I've also found some suggesting SUMPRODUCT, but it just doesn't seem to work for me.

Please help!
Thanks.

that is currently working. I need to add a bit more data to test it, but THANK YOU!!!