SUMIF

[Frank Kabel]

Hi
see your other post

P.S.: please don't multipost

-----Original Message-----
A B
456N 1000
567N 2000
678N 1000
0452 1500
2549 2000

I am trying to SUM B:B ONLY if it contains 456N, OR 567N, OR 678N.
I have tried:
SUMIF(A:A={"456N","567N","678N"},B:B)
This only seems to pick up the first number (456N) and

not the other 2. Is there another way I should be doing
this??

 

[Debra Dalgleish]

The Microsoft Web interface has been broken for a couple of days. People
were multiposting because their messages weren't appearing.

 

[Frank Kabel]

Hi Debra
thanks for the info