Could you help with SUMPRODUCT

[Sean15]

Hi:

I have serial numbers in column K and prices in column S.
I want to add all prices in column S for all serial numbers in column K that begin with 4010
The formula below is returning #Value!

=SUMPRODUCT((LEFT(K16:K48,4)+0=4010)*(S16:S48)).

Could you help please?

Regards,
Sean

 

[DanteAmor]

Try this

Book1
	A									J	K								S	T	U	V
1
15
16											4010a1								1		35
17											4010a2								2
18											4010a3								3
19											4010a4								4
20											4010a5								5
21											5013a1								6
22											5013a1								7
23											5013a1								8
24											4010a4								9
25											5013a1								10
26											4010a2								11
27
Hoja18

Cell Formulas
Range	Formula
U16	U16	=SUMIF(K16:K26,"4010*",S16:S26)

 

[DanteAmor]

Or sumproduct:

=SUMPRODUCT((LEFT(K16:K48,4)="4010")*(S16:S48))

 

[Sean15]

@DanteAmor

I'll go with your SUMPRODUCT formula.

Thank you very much.

Regards
Sean

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.