I'm trying to use the Countif (or other) function across non-adjacent cells
in a long column in order to count the number of occurances of specific cells
that exceed a limit. The application is the 31 days of the month with 24
hours following each day. The hourly rows are grouped (normally hidden) and
do not directly relate to the daily information being counted. I just want to
count the daily occurances of a limit being exceeded. Something like:
Countif((B1 or B25 or or B50 ...31st day), "3.3")
Data example
1/1/05 3.0
cells with hours (skip next 24)
1/2/05 3.4
cells with hours (skip next 24)