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:
http://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=39601)+AND($G$3:$G$8=39601)))
Is anyone can help?
It is quiet urgent...
I'm trying to get help in amother forum you can have a look ant try to understand:
http://www.excelforum.com/showthread.php?p=1938011#post1938011
Many thanks in advance,
Amir
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:
http://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=39601)+AND($G$3:$G$8=39601)))
Is anyone can help?
It is quiet urgent...
I'm trying to get help in amother forum you can have a look ant try to understand:
http://www.excelforum.com/showthread.php?p=1938011#post1938011
Many thanks in advance,
Amir