I have a table I am trying to pull data from but I can't seem to get my
formula to work properly.

=SUMPRODUCT((Query!$F$2:$F$66="JDoe")*(Query!$C$2: $C$66="Inbound"))*(Query!K:K=7/26/2004)

Basically I have a table with the username, whether it was inbound or
outbound, and the date of call. I am trying to pull the Inbound calls
for JDoe on 7/26 but the formula does not seem to be reading my last
criteria as a date. I tried apostraphe's and quotes and neither helped.


Is there a sybmol that I am missing or a better way to be going about
this? One person at work suggested a countif with other nested
countif's but didn't have time to explain the logic. Any help would be
greatly appreciated. Thanks guys


---
Message posted from http://www.ExcelForum.com/