SUMIF with more than one criteria

P

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
Click to expand...
456N or 789W. I have tried sumproduct also, but it tells
me I do not have enough arguments. PLEASE HELP!!!
 
Top