Suppose your dollars are in column B and the rpoductname in column C, then
use something like this

=SUMPRODUCT(B1:B10,--(LEFT(C1:C10,2)="cand"))

Mangesh




"Matz" wrote in message
...
If i have several rows with product data is there a way to get it to
search
for hits simular to the first 4 letters ? then of course sumit up to 1
result.

for exampel:
the data sheet:

21 units 200$ candyliqurish
50 units 200$ candyfudge
20 units 300$ candylollypop

the result sheet:

91 units 700$ candy*****

this forum i sthe best !!

thanks to all competent people !

best regards Matz