Hi what i´m trying to do is counting how many times a club win, draw or loose, but i only want the last 4 results, not the whole count: i will place here an example:
=COUNT.IF.S(A:A;"<"&A1;B:B;B1;L:L;"WIN";AC:AC;AC1;AD:AD;AD1)
This Formula is asking to count (A:A) DATE < DATE IN CELL A1;
(B:B) TEAM = TEAM IN CELL B1
(L:L) WIN DRAW OR LOOSE
(AC:AC) & (AD:AD) ARE THE FIELD FOR COUNTRY AND LEAGUE
This formula will tell me how many times that team have won before that date, but i only want the last 4,5 or 6 results.
Can someone tell me what to do. Thanks in advance.