Digita
05-11-2009, 06:40 PM
Hi guys,
I need some help from formula experts and attach a small sample for your reference.
The dates when each order is received and when it is completed and despatched are logged in column A & B respectively.
I want to count the number of outstanding orders in each day. Any orders which are completed on same date are excluded. My sumproduct formula in column F needs to be modified to include items without a completion date in column B as well.
Thanks in advance.
Regards
kp
I need some help from formula experts and attach a small sample for your reference.
The dates when each order is received and when it is completed and despatched are logged in column A & B respectively.
I want to count the number of outstanding orders in each day. Any orders which are completed on same date are excluded. My sumproduct formula in column F needs to be modified to include items without a completion date in column B as well.
Thanks in advance.
Regards
kp