Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why is there a { in my formula and why wont it work? | Excel Discussion (Misc queries) | |||
cntrl+n wont work | Excel Discussion (Misc queries) | |||
IF sum is GreaterThan 0... why wont this work!? | Excel Worksheet Functions | |||
Multiple conditions...why wont this work? | Excel Worksheet Functions | |||
Control + C wont work | Excel Discussion (Misc queries) |