Sumproduct wont work
 

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/

Sumproduct wont work
 

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)))

In article ,
Mycotopian wrote:

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/

Sumproduct wont work
 

Maybe a little typo in JE's formula?

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

Regards,

Daniel M.

"Mycotopian " wrote in message
...
I copied your formula and pasted it into the cell and it is still not
pulling any records. My dates on the table are formatted as 7/26/2004
do I need to change it?


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