Forum Discussion
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 in...
That only counts the number of rows marked Practice. I'm trying to count the number of data points within those rows marked "Practice"
=SUM((A3:A75="practice")*(B3:E75<>""))- THANK YOU! With the exception of the array should be C3:E75 (date doesn't count)
- Quadruple_Pawn mentioned a second option that also works and is more what I expected. =COUNT(FILTER(C5:E75, $A$5:$A$75="practice"))
ALSO works and although I thought I had tried that I must have missed something in the syntax.