sumif from an array

[Jeff]

Hi,

Does anyone know how I can make this happen.

=sumif(B1:B10,OR('1','48A','3/2'),C1:10)

Where the OR bit is an array of random values. But I don't
think you can put an array in the conditions for sumif.
Does anyone know a better way to do it?

Please

 

[Frank Kabel]

Hi Jeff
one way: try
=SUMPRODUCT(((B1:B10="1")+(B1:B10="48A")+(B1:B10="3/2")),C1:C10)

 

[JE McGimpsey]

One way:

=SUMPRODUCT((B1:B10={"1","48A","3/2"})*C1:C10)

 

[Frank Kabel]

Another way:
=SUMPRODUCT((B1:B10={"1","48A","3/2"})*(C1:C10))

 

[Tom Ogilvy]

=SUM(SUMIF(B1:B10,{"1","48A","3/2"},C1:C10))

Worked for me.

3/2 seems to match Mar 2, 2004 or the string 3/2, but not the number 3/2
(1.5)

"1" matches the number 1 or the string "1"