Hello

I have a table of data showing the "flow" in one column and "hour ending" in another column. I have the formula =COUNTIF(A2:A8761,">=600") to show how many in the flow column are over capacity (i.e. over 600). What I then want to do is find out how many of this result (the number output was 974) have the "hour ending" of 1, then 2, then 3 etc up to 24. Preferably I'd like the whole thing to be done in one formula. I can't get my head around how to do this.

This is a quick extract from the spreadsheet

Flow Hr Ending
206 1
182 1
162 1
156 1

I have sorted the data into ascending order by "Hr Ending". If anyone can help I will be very grateful.

Thanks