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