Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |