Patcheen
Active Member
- Joined
- Sep 28, 2015
- Messages
- 391
- Office Version
- 365
- Platform
- Windows
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
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 |