Help with sumproduct function

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

Guys,

I think I got this problem sorted. In cell F2, I have:

Code:

---

=SUMPRODUCT(--(A$2:A$629<=E2),--(B$2:B$629>E2))+SUMPRODUCT(--(B$2:B$629<=E2),--(B$2:B$629=0))

---

Regards


kp

You could combine them

Code:

---

=SUMPRODUCT(((A$2:A$629<=E2)*(B$2:B$629>E2))
+((B$2:B$629<=E2)*(B$2:B$629=0))

---

Wow. Never thought it's possible. Thanks Bob.