Thread: sumproduct

Anyone, any suggestions??

Thanks,

Amir

You have crossposted here:

http://www.mrexcel.com/forum/showthread.php?t=328419

Originally Posted by NBVC

You have crossposted here:

http://www.mrexcel.com/forum/showthread.php?t=328419

Thought it's different forum, just trying to get help.

Thanks,

Amir

Your logic is not easy to follow....

If you can explain, in words, the logic that the formula should have, then perhaps someone can help...



P.S. It is a different forum that you have crossposted to... our rules specify that you must indicate that you have crossposted elsewhere...

Hi,
First sorry didn't mean to break the rules.

Now,
I have 3 columns of dates.
It is possible that the 3 of them will have diferent dates.
I have 44 lines to distribute the samples.
Some of them I get in few shipments, therefor it might be processed in several dates.

What I need is that the formula will show me how many pieces I processed for each line in each day.

Next to each date column there is a quantity column.

To each line that get sample we mark it with: box #.

The formula that I'm using now showing me only by the first column of the date.
For example I got 10 pieces on the 02/06 it showing me the 02/06.
The rest I got on 03/06, it showing me that I processed it on the 02/06 instead of the 02/06.

I hope it's clear now and sorry again for not reading the rules.

Thanks,

Amir