SUMPRODUCT(--(MOD(OFFSET(C1,COUNTA(Dynamic Range),2)=1)) - Too few arguments - Why?

[Poker Joe]

I need to enter a formula that will automatically update as I enter data daily. I'm attempting to use a dynamic range within the formula.

The formula in "I2" will find how many odd numbers are in the data (rows of data in C:G) for the last 5 days but I have to adjust the range every time I enter new data.

This is my attempt for a dynamic range within the formula in I2, =SUMPRODUCT(--(MOD(OFFSET(C1,COUNTA(C2:G1500,0,-5,1),2)=1))

Microsoft gives an error message that I've entered too few arguments. Once I select "OK" on the error message, the last "1" in the formula bar is highlighted.

I'm lost. Thanks in advance to anyone that can assist.

Book1.xlsx
	A	B	C	D	E	F	G	H	I	J
1	ID	Date	Team1	Team2	Team3	Team 4	Team5		Odd	Even
2	1	44927	1	6	3	3	8	Last 5 Days	=SUMPRODUCT(--(MOD(C17:G21,2)=1))	=25-I2
3	2	44928	2	7	4	4	9
4	3	44929	3	8	5	7	3	Last 5 Days
5	4	44930	4	9	6	8	4	Dynamic Range	=SUMPRODUCT(--(MOD(OFFSET(C1,COUNTA(C2:G1500,0,-5,1),2)=1))
6	5	44931	5	10	1	9	5		You've entered too few arguments for this function
7	6	44932	3	8	5	7	4		After selecting OK on the Microsoft Error message, it highlights the last
8	7	44933	4	9	6	3	1		"1" in the formula.
9	8	44934	7	3	4	9	6
10	9	44935	8	4	5	10	1
11	10	44936	9	5	3	8	5
12	11	44937	10	6	4	9	6
13	12	44938	8	4	9	6	8
14	13	44939	3	8	5	7	3
15	14	44940	4	9	6	3	4
16	15	44941	7	3	4	9	5
17	16	44942	8	4	5	10	6
18	17	44943	2	7	4	4	9
19	18	44944	3	8	5	7	3
20	19	44945	4	9	6	8	4
21	20	44946	5	10	1	9	5
22
23
Sheet1

Cell Formulas
Range	Formula
I2	I2	=SUMPRODUCT(--(MOD(C17:G21,2)=1))
J2	J2	=25-I2

 

[Fluff]

Glad it's sorted & thanks for the feedback.