Extracting data

[amir2000]

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=39601)+AND($G$3:$G$8=39601)))

Is anyone can help?

Many thanks in advance,

Amir

 

[Dave Peterson]

Maybe...

=SUMPRODUCT(--($I$3:$I$8<>""),
--((($C$3:$C$8=39601)+($E$3:$E$8=39601)+($G$3:$G$8=39601))>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]

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

 

[amir2000]

Any suggestions???

Thaks,

Amir