Formula to Lookup multiple values and Sum them.

[yemnirmal]

Hi Excel Users,

Kindly help me with a formula to lookup few values and sum their corresponding values.

Find the attached sheet for example.

I want the sum of values of A,B and C together. (Totalling=9)

Kindly help me.!!

[samba_ravi]

Try
=SUMPRODUCT((A3:A7={"A","B","C"})*(B3:B7))

[samba_ravi]

or
=SUM(SUMIF(A3:A7,{"A","B","C"},B3:B7))