SUMIF function

[FLKulchar]

How do I sum a column of numbers if I ONLY wish to sum
the numbers that are EITHER 2 OR 4.

For example, my A column array has the following numbers

A1 5
A2 2
A3 2
A4 4
A5 6
A6 8
A7 7
A8 9
A9 4
A10 6

The =SUM function returns 53 as a value.

The =SUMIF(A1:A10,2) returns 4 as a value.
The =SUMIF(A1:A10,4) returns 8 as a value.

HOW DO I COMBINE THE LAST TO SUMIF's using, perhaps,
an "OR" formula, or WHATEVER.

This does NOT work: =SUMIF(A1:A10,"OR(2,4)")

PLEASE HELP!!

thanks,

Larry

 

[Nick]

try
=SUMIF(C1:C10,2)+SUMIF(C1:C10,4)

 

[JMay]

Nick,
Can the Sumproduct() formula be used to get the 12 answer?
If so, how? I can't get it to work.
TIA,

 

[Roger Govier]

Hi
Try
=SUMPRODUCT((A1:A10<>4)*(A1:A10<>2)*A1:A10)