SUMPRODUCT or array formula help please!

I need to create a formula to calculate the total amount from any investment into Schroder from the following example list:

Please Login or Register  to view this content.

So the formula would need to ensure that only the figures from column B are counted when the first 8 characters in column A = "schroder".

The total in the above example would be £38,000.

I've tried a SUMPRODUCT formula, namely:

SUMPRODUCT((B1:B5)*(LEFT(A1:A5, 8) = "schroder"))

But this doesn't work. I think you can see what I'm trying to achieve.

Maybe an array formular will solve this, but I'm not experienced enough with them.

Please could you point me in the right direction? Thanks!

Thanks, that's solved it perfectly!!!

I don't see why

=SUMPRODUCT((B1:B5)*(LEFT(A1:A5,8)="schroder"))

doesn't work, unless you have spaces or other non-printing characters at the start.....but you don't need SUMPRODUCT for a single criterion, SUMIF will suffice

=SUMIF(A1:A5,"*schroder*",B1:B5)