This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
the article is indeed helpful but unfortunatelly it does not solve my Question. If you click in the Formula in the H2 cell of the attached Excel file you will see that in the row 2 the Formula considers rows 2-32, in the row 3 Formula considers 3-33, in the 4th row 4-34 rows, and so on....each next 30 rows. In short the sumifs, countifs, usually consider static table and my Formula "moves" downwards and considers "new table" in each new row. In the example provided you group by the Name of the player, which repeats in your static table, the same way counting works in databese. But my case is different, becuase I do not have Value (date in my case) that repeats in the "start_date" column, but ratcher considers the values of certain column in the following 30 rows.
I would be happy on update to my Question. THANK YOU