How to count total no. of Cells in a column that has Vlookup values (good & garbage values

[jayteja]

Hi,

I have a database of 20 with names and Dates (Not all Names have dates in front of them). Lets say I have a random list of 10 names out of those 20.

Now I do a vlookup for those 10 names and get the dates. So lets says I get 5 correct dates and 5 garbage values as those dates are not present in the original list of 20.

My question is what formula do I use to count the total cells in the list of 10 with 5 good values. I mean I should get the count as 5 (because 5 values are good). The formula should not count the 5 garbage values. Once I update a date in the list of 20, the vlookup should automatically take that date and put it in the list of 10 and the count should show me 6 (with 4 garbage values).

Can somebody please help me here. When I use countA function it is giving me the result as 10 which is wrong. Hence I need help.

Thanks.

[nemo74]

Sample file please with what you would like the result to be. This will speed up the help process quite a bit.