Using SEARCH for Columns

I'm thinking...
=SUMIFS(B:B,C:C,"",A:A,A1)
in D1, copied down.

However, you will get the same "sum" result for every row that has the same name in column A...

If you want to put the name in each formula as you go down column D, replace A1 in formula with "name". The other option is to change the reference to E1, and put the name in column E, of course.

Originally Posted by Shippior

In the end I decided to go with the solution Mazzaropi gave as I thought it was the most clear.

If you're using Excel 2010 as your profile indicates then you can use the more efficient SUMIFS function:

=SUMIFS(B1:B10,A1:A10,A2,C1:C10,"<>")

You may have to replace the commas with semi-colons depending on your regional settings.