Counif - dates vs. Timestamps

[MarkCBB]

HI there,

I need some formula assistance with a countif formula, the range consists of date/Time stamps, by my criteria is based only by date, I am looking for the count of all the dateTimestamps in the date criteria.

 

[barry houdini]

If you have the timestamps in column A and a date in C1 them use this formla to count all the entries on that date

=SUMPRODUCT((INT(A$2:A$100)=C1)+0)

 

[MarkCBB]

This is the formula that I am trying to fix, there are a few arguments,

EMS_DB is the database "L"= Date

=COUNTIFS(EMS_DB!$L:$L,EMS_REPORTS!$P2,EMS_DB!$H:$H,EMS_REPORTS!$T$1,EMS_DB!$V:$V,EMS_REPORTS!$Q$1)

 

[barry houdini]

So I assume that EMS_REPORTS!$P2 contains a specific date?

Try this version

=COUNTIFS(EMS_DB!$L:$L,">="&EMS_REPORTS!$P2,EMS_DB!$L:$L,"<"&EMS_REPORTS!$P2+1,EMS_DB!$H:$H,EMS_REPORTS!$T$1,EMS_DB!$V:$V,EMS_REPORTS!$Q$1)

 

[MarkCBB]

ahhhh, i see, I was pretty close, I didnt think to "+1" to get the right range. I didnt understand that I was making my criteria nothing, Thanks Barry, very clever, its working prefectly now. AWESOMENESS!!!