Calculate SUM, under 1 condition

Try this...

Data Range

	A	B	C	D	E
1	Textfield	Numbers	------	Counted:	1246
2	Lorem ipsum	45
3	dolor sit cu solet	364		cu solet	1246
4	verit eam, muciu	4997
5	cu solets, pri cu sol	31
6	s accumsan tr cu solet	46
7	scripta luptatum nam	564
8	ition cu soletem vim. Fas	7
9	mi duo at. Err	5
10	tion graecis,	7
11	fastidii du	1
12	cibo percipi	117
13	vim cu solet cu.	798

This formula entered in E3:

=SUMIF(A2:A13,"*"&D3&"*",B2:B13)

You may have to replace the commas with semi-colons.