This should be simple :face_with_steam_from_nose:. I have a simple table with 8 columns and 75 rows. Each row (column A) is either labeled (Practice) or left blank. Column B is given the date of the data, columns C, D, E include the data score of those dates. So, there are essentially 225 total possible data points, although not every cell has an entry. In a remote cell I have created a formula that tracks average score within the cells as an entirety. I have created another cell that tracks the average score of the cells where column A is marked practice. Using =AVERAGE(FILTER(c5:e75, $a$5:$a$75="practice")). That works perfectly. I would also like to know the exact number of data points . I tried using COUNTIF with the same format but it does not work. I have moved syntax around, tried different variations and I either get ALL the data points counted , or I get SPILL error. What am I doing wrong?
