another sumproduct question

[cjjoo]

i got alot of columns in a sheet and i want to use the sumproduct to
calculate

the sum of a vehicle no based on a few criterias(e.g) =sumproduct(--

(a1:a100="A"),--(b1:b100="b"),--( the problem lies here), K1:k100).

In "the problem lies here" criteria, the column (C1:c100) is
description on the

parts purchased . but what i want to sum is those entries that has
the

words "To replace" in front of the entire description. The description
can be like:

To replace tyre no 5

It is better to use substitute, replace or left or all of them ? pls
advise . thank u

 

[duane]

try using --(left(the range,10)="To replace")