Vlookup & count

Dear All,

I have attached one excel, Where Column B have Dates and Column C having month (Just by formatting the dates to show only month).

Now i have per-populated month list in column H having months. I want output in Column I as # of Contracts for that particular month, which is nothing but count of same months in Column C matched against Months in Column H.

(For ex. in Column I , Apr'14 should display 5 # of contracts)

Please Help. VLOOKUP is not working since Column C method of extracting months is not working and Column C & Column H months not matching.

Regards
Mohammad

Thanks a lot Ace. It is perfect.

Now i need one more help , in the same excel I've added Column I "PO to delivery Average Days", where i require Average of Number of days for that particular month as mentioned in column D,

I would appreciate your help.

Regards
Mohammad

Hello nflsales, This works perfect but if you replace any of the Apr'14 PO delivery days to zero or make that cell empty , this formula still calculate average by Total number of Apr month ( 5), ideally it should take as 4 to calculate average.

Regards
Mohammad

Hello Nfls,


Sorry to bother you again but i don't know why this is not working in my working file however it works well in test file. I have attached my working file for your review. Is it because of the ways PO to delivery days are calculated in Column D, where as in test file i've entered them as absolute number without using the formula.

Please help.

Regards
Mohammad