scored in last 10 games

[Patcheen]

Im trying to count how many times a goal was scored in last 10 games

the formula i tried using is =COUNTIFS(E6:E28>0,I6:I28,"home",SEQUENCE(10)) but when i press enter it says - "There is a problem with the formula" and wont go any further

any help in solving this would be great - Thank you

Book1
	E	F	G	H	I
6	5				Home
7	2				Away
8	2				Home
9	2				Home
10	2				Away
11	2				Away
12	1				Home
13	2				Home
14	0				Away
15	3				Away
16	4				Home
17	2				Away
18	2				Home
19	2				Home
20	1				Away
21	0				Home
22	3				Away
23	2				Home
24	0				Away
25	2				Away
26	4				Home
27	1				Away
28	5				Home
Sheet1

 

[awoohaw]

You don't have labels on your data? Is every two rows one match, or is this the history of one team over all the matches? Which match is the most recent, is row 5 most recent or most distant?

 

[Fluff]

If the last 10 games are the bottom rows, maybe

=SUM(SIGN(TAKE(FILTER(E6:E28,I6:I28="home"),-10)))

 

[Patcheen]

Thank you all for the help sorted thank you

 

[Fluff]

Glad we could help & thanks for the feedback.