Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting data
Hi All
I have a table with 3 columns of dates and then a column with Set # that I feel in the box #. I need to see how many items processed for each set per day. Example: www.amir2000.nl/1.doc The problem is that it counts the correct amount but not with the correct dates. The formula that I use is: =SUMPRODUCT(--($I$3:$I$8<"")*(($C$3:$C$8=39601)+AND($E$3:$E$8=3 9601)+AND($G$3:$G$8=39601))) Is anyone can help? Many thanks in advance, Amir |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting data
Maybe...
=SUMPRODUCT(--($I$3:$I$8<""), --((($C$3:$C$8=39601)+($E$3:$E$8=39601)+($G$3:$G$8=3 9601))0)) But I'd use: =SUMPRODUCT(--($I$3:$I$8<""), --((($C$3:$C$8=date(2008,6,2)) +($E$3:$E$8=date(2008,6,2)) +($G$3:$G$8=date(2008,6,2)))0)) (or put the date in a different cell and use that cell in the formula. amir2000 wrote: Hi All I have a table with 3 columns of dates and then a column with Set # that I feel in the box #. I need to see how many items processed for each set per day. Example: www.amir2000.nl/1.doc The problem is that it counts the correct amount but not with the correct dates. The formula that I use is: =SUMPRODUCT(--($I$3:$I$8<"")*(($C$3:$C$8=39601)+AND($E$3:$E$8=3 9601)+AND($G$3:$G$8=39601))) Is anyone can help? Many thanks in advance, Amir -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting data
Hi again
Thanks but it's giving me the same result. For examole in set 4 i processed 3 on the: 03/06, 05/06 and 06/06. The formula shows: 02/06,03/06 and 04/06. For some reason it shows only the first date column. It counting ok but by the date. Thanks, Amir -- www.amir2000.nl "Dave Peterson" wrote: Maybe... =SUMPRODUCT(--($I$3:$I$8<""), --((($C$3:$C$8=39601)+($E$3:$E$8=39601)+($G$3:$G$8=3 9601))0)) But I'd use: =SUMPRODUCT(--($I$3:$I$8<""), --((($C$3:$C$8=date(2008,6,2)) +($E$3:$E$8=date(2008,6,2)) +($G$3:$G$8=date(2008,6,2)))0)) (or put the date in a different cell and use that cell in the formula. amir2000 wrote: Hi All I have a table with 3 columns of dates and then a column with Set # that I feel in the box #. I need to see how many items processed for each set per day. Example: www.amir2000.nl/1.doc The problem is that it counts the correct amount but not with the correct dates. The formula that I use is: =SUMPRODUCT(--($I$3:$I$8<"")*(($C$3:$C$8=39601)+AND($E$3:$E$8=3 9601)+AND($G$3:$G$8=39601))) Is anyone can help? Many thanks in advance, Amir -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting data
Any suggestions???
Thaks, Amir -- www.amir2000.nl "amir2000" wrote: Hi again Thanks but it's giving me the same result. For examole in set 4 i processed 3 on the: 03/06, 05/06 and 06/06. The formula shows: 02/06,03/06 and 04/06. For some reason it shows only the first date column. It counting ok but by the date. Thanks, Amir -- www.amir2000.nl "Dave Peterson" wrote: Maybe... =SUMPRODUCT(--($I$3:$I$8<""), --((($C$3:$C$8=39601)+($E$3:$E$8=39601)+($G$3:$G$8=3 9601))0)) But I'd use: =SUMPRODUCT(--($I$3:$I$8<""), --((($C$3:$C$8=date(2008,6,2)) +($E$3:$E$8=date(2008,6,2)) +($G$3:$G$8=date(2008,6,2)))0)) (or put the date in a different cell and use that cell in the formula. amir2000 wrote: Hi All I have a table with 3 columns of dates and then a column with Set # that I feel in the box #. I need to see how many items processed for each set per day. Example: www.amir2000.nl/1.doc The problem is that it counts the correct amount but not with the correct dates. The formula that I use is: =SUMPRODUCT(--($I$3:$I$8<"")*(($C$3:$C$8=39601)+AND($E$3:$E$8=3 9601)+AND($G$3:$G$8=39601))) Is anyone can help? Many thanks in advance, Amir -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting data | Excel Worksheet Functions | |||
Extracting Data for .Txt Files By Unique Field Data | Excel Discussion (Misc queries) | |||
Extracting data | Excel Discussion (Misc queries) | |||
extracting data | Excel Discussion (Misc queries) | |||
extracting data | Excel Worksheet Functions |