i'm sorry I copied paste the wrong formula,

I meant if I wanted to use SUMIF

SUM(SUMIF(A2:A14,{"a","b","c","d","e"},B2:B14))

how can i reference cells instead, because it's not working out how I want it

SUM(SUMIF(A2:A14,(A2,A3,A4,A5),B2:B14))

it doesn't seem to work as the sum comes out wrong.