How to sum Odd OR Evens

[Richard100]

G'day
I have 6 numbers in a row, like to sum odd numbers or even numbers.
1 2 3 4 5 6 like to sum odd numbers OR even numbers (lotto draw)

 

[FormR]

Hi, welcome to the board!

Without questioning your motives - here is one option.

Book2
	A	B	C	D	E	F	G	H	I
1								Odd sum	Even sum
2	1	2	3	4	5	6		9	12
Sheet1

Cell Formulas
Range	Formula
H2	H2	=SUMPRODUCT(--(MOD(A2:F2,2)>0),A2:F2)
I2	I2	=SUMPRODUCT(--(MOD(A2:F2,2)=0),A2:F2)

 

[sykes]

You could have a look at this.