COUNTIFS a simple date from a list of dates & times

[xcracer41]

Im trying to count the simple dates in a list of dates and times


Excel.PNG

[GC Excel]

Hi,

Here's one possible solution :

Please Login or Register  to view this content.

[xcracer41]

This works, but I'll also need to add other criteria

[GC Excel]

Hi,
what are the other criterias that you need to add?
It is possible to add criterias with SUMPRODUCT.

Can you share a workbook with sample data... If would be much easier to work with a workbook that with an image...
Thanks