I don't see it.

???

Biff

"Sandy Mann" wrote in message
...
Biff,

I assume that you have worked out by now that there is a flaw in the OP's
logic that by giving him/her what he/she asked for you have continued.

--
Rergards


Sandy

Replace@mailinator with @tiscali.co.uk


"Biff" wrote in message
...
Hi!

the result: 89-65=34.

You sure it isn't 24?

Try this entered as an array using the key combo of CTRL,SHIFT,ENTER:

=MAX(IF((A1:A3="x123")*(D1:D3=4),C1:C3))-MIN(IF((A1:A3="x123")*(D1:D3=4),C1:C3))

Biff

"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