SUMIF with more than one criteria

[Patti]

How about:

=Sum(Sumif(A:A,{"770N","456N","789W"},B:B))

-----Original Message-----
I am using SUMIF to sum a range with certain criteria in another range.
i.e.

A B
770N 5000
456N 1000
789W 2000
567W 3000
852B 4000

I need to sum the values in B ONLY if A contains 770N, 456N, OR 789W. I tried this:
SUMIF(A:A,{"770N","456N","789W"},B:B)
this has only picked up the 770n in column A, not the

456N or 789W. I have tried sumproduct also, but it tells
me I do not have enough arguments. PLEASE HELP!!!