Urgent! Need help with counting functions

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

Hi all,

I'm using Excel XP, and need some help in figuring out how to count
rows with 2 sets of criteria.

Here is the situation:

I want to count customers that start with a particular string. No
problem there, Countif(range, criteria) gives me what I need.

But I then want to get a count of these filtered by another column.

So say I get 50 rows of customers starting with "AMER", I want to look
into a date column (that is itself a Vlookup formula), and get a count
of the "AMER" customers that have a date in the date column. Now the
date colum might have #N/A in it due to the VLookup failing.

I've tried =SumProduct((Customer="amer*")*(date<>"#n/A")) and just get
a #N/A for a result.

help!!!!

Thanks

Craig
 
Back
Top