Countif only if another column is not blank...

[corsabrin]

Hello,

I have a list of parts in column A that is about 200 rows or so. There are only a dozen parts or so that repeat multiple times. I then have about 20 columns of data for each part. Column K is "Customer".

What I need to do is count the number of each part in column A. That was done with a simple countif formula. Now I need to count each part in column A only if a cumster name is listed column K (this column is left blank until a customer is added). I can't seem to get this to work. Let me know if you need me to be more specific.

Please help!

Thanks!

 

[corsabrin]

Thanks again DonkeyOte. I just added an extra 100 rows as I don't think it will go over that amount anytime soon. I am using Excel 2003, so that is why it didn't work.

Thanks again for all the help and the quick replies!