CountIfs to see how many Dated in Column N are greater than Column M

[USAMax]

I have multiple criteria and the last one is comparing two columns with dates. Here is what I have so far:

=COUNTIFS('eMail Tracker'!A:A,"<>",'eMail Tracker'!K:K,"",'eMail Tracker'!O:O,">" & NOW()-1,'eMail Tracker'!M:M,"<" & 'eMail Tracker'!N:N)

This checks for:
Column A is not blank
Column K is blank
Column 0 is within the last 24 hours
Column M is less than Column N (These columns are both dates with time.)

 

[wideboydixon]

With the last criteria, I think you'll need to convert this to a SUMPRODUCT:

=SUMPRODUCT(('eMail Tracker'!A:A<>"")*('eMail Tracker'!K:K="")*('eMail Tracker'!O:O>(NOW()-1))*('eMail Tracker'!M:M<'eMail Tracker'!N:N))

WBD

 

[USAMax]

wideboydixon, I must have been sick the day they taught * with SUMPRODUCT!

This is perfect, thank you!