Counting values in column
Hi, I need help using the Count function. I think I may be able to us this for what I need but not sure how. I've attached a sample data table. For the Column "day night 5 min intervals" I want to use a formula to count the number of values of the same number in the column "Counter" (This is to help me calculate the length of day and length of night) I created the day or night columns and the...