a

[Matt_Chelmsford]

Excel 2010

	A	B	C
1	name	Q	Amount
2	John Smith	3	14.00
3	John Davis	23	12.00
4	John Wallace	23	16.00
5	Brian Jones	5	2.00
6	Roy Bittan	14	0.00
7	Glen Hoddle	5	0.00

<COLGROUP><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
</TBODY>

Sheet3​

Worksheet Formulas Cell Formula B13 =SUMPRODUCT(B2:B7,C2:C7)*(--ISNUMBER(FIND(A13,A2:A7,0))) (A13 is just John) <THEAD> </THEAD><TBODY> </TBODY>

<TBODY>
</TBODY>

I am having trouble with this formula. I want to sumproduct anything that begins with John.

kind Regards

Matthew

 

[Jonmo1]

You might want to edit your title to something a "Tad" more descriptive than just "a"

Try
=SUMPRODUCT(--(LEFT(A2:A7,LEN(A13))=A13),B2:B7,C2:C7)