=SUMPRODUCT(--(A2:A20="x123"),--(D2:D20=4),C2:C20-B2:B20)
but I get 23
--
HTH
Bob Phillips
"cjjoo" wrote in
message ...
THEIS IS MY PROBLEM:
vehicle no start km end km tyre location
x123 56 65 4
x123 65 75 1
x123 75 89 4
i want to sum the distance the vehicle x123 has travelled when tyre
location is 4.
the result: 89-65=34.
Can i use sum product?
--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=474676