Forum Discussion

MobeeDick's avatar
MobeeDick
Copper Contributor
Jul 04, 2023

Formula for counting data points

This should be simple 😤. 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?

5 Replies

Resources