A
adimar
I'm looking for a formula that returns number of items delivered on time.
Ex: How many items "Apple" were delivered on time in the table below.
A B C
Item Requested Delivered
==== ========= =========
1 Apple 2/1/07 3/1/07
2 Apple 2/5/07 2/5/07
3 Orange 2/3/07 4/1/07
4 Apple 2/3/07 2/2/07
5 Apple 2/15/07 2/20/07
sumproduct(($A1:$5="Apple")*($B$1:$B$5=$C$1:$C$5)) doesn't work...
Ex: How many items "Apple" were delivered on time in the table below.
A B C
Item Requested Delivered
==== ========= =========
1 Apple 2/1/07 3/1/07
2 Apple 2/5/07 2/5/07
3 Orange 2/3/07 4/1/07
4 Apple 2/3/07 2/2/07
5 Apple 2/15/07 2/20/07
sumproduct(($A1:$5="Apple")*($B$1:$B$5=$C$1:$C$5)) doesn't work...