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...
=COUNTIF($a$5:$a$75;"practice")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)
