I am having a problem creating an sumifs statement in VBA

I have two columns, column "a" contains text and column "b" contains values.

I would like to search column "a" for certain text and add the value from it.

SUMIFS(B2:B8,A2:A8, "*Cash*")