Sum up based on specific text with a text string

[pmw19800]

hello All

Please see the attached

i need a formula that looks upa 'part a text string then and then adds the total together

J5 – Looks for 663AGRP STD and then sums column C
I have manually put some expected data in



Paul

[canapone]

Hi

in K5 and below

=SUMPRODUCT(--(LEFT(B$2:B$106,LEN(J5))=J5),C$2:C$106)

Regards

[Bo_Ry]

Please try at K5
=SUMIFS(C:C,B:B,J5&"*")

[pmw19800]

both work great,

Bo_Ry - sollution very useful