open_in_new content_copy
=SUMIFS(A2:A9,B2:B9,"=A*",C2:C9,"Tom")
open_in_new MORE content_copy COPY

@zscherrer at thiscodeWorks.com