Sumproduct wont work

M

Mycotopian

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
 
J

JE McGimpsey

You can't use entire columns in an array formula, and all arrays have to
have the same size. Try:


=SUMPRODUCT(--(Query!$F$2:$F$66="JDoe"),--(Query!$C$2:$C$66="Inbound"),
--(Query!$K$2:$K$66=DATE(2004,7,6)))
 
M

Mycotopian

I copied your formula and pasted it into the cell and it is still no
pulling any records. My dates on the table are formatted as 7/26/200
do I need to change it
 
D

Daniel.M

Maybe a little typo in JE's formula?

Change
DATE(2004,7,6) to
DATE(2004,7,26)

Regards,

Daniel M.
 
Top