Need help with formula

[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:
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

 

[Dave Patton]

Hello Amir and welcome to the forum.

I did not tour the site to see your example.

I put the date of interest in a cell A3 and I read your question as the date must be in the 3 columns and the amount to be summed is column I.

=SUMPRODUCT(--($I$3:$I$8<>""),--($C$3:$C$8=A3),--($E$3:$E$8=A3),--($G$3:$G$8=A3),($I$3:$I$8))

 

[amir2000]

Hi ,
No it does not help.

Thanks,
Amir