Sumproduct error

Hi Sifu excel,

I'm having problem using SUMPRODUCT, I'm having problem to count based on Column P (Date) of how many interview scheduled reflect on M.Report worksheet.

Thank you,

puffyboy

Try this in D10 and copy down.

Please Login or Register  to view this content.

Thank you, work fine

You are welcome.

try another option

Worksheet or Tab name : M.Report

Cell d10 formula drag down

Formula:

Please Login or Register  to view this content.