Number of days per month if a column has a consecutive value above "x"

[Nando24]

Hi all!

Can't figure this one out. I need to find the number of days by month when the speed of wind is above 10 for different consecutive time frames (1 to 2 hours, 2 to 4 hours. 4 to 6 hours). I've tried many formulas in various threads and none seem to work.

Ultimately, I need a table showing the days per month with these two criterias 1) above 10 mph 2) within consecutive time frames


2015.12 2016.01 2016.02
1 to 2 hours 8
2 to 4 hours 1
4 to 6 hours 0
6 to 8 hours 0


Any Ideas?

Thanks in advance!

FZ

[FlameRetired]

Hi Nando24. Welcome to the forum.

I can't seem to come up with the same figures you post. Array enter this in cell K4, fill down and across. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Please Login or Register  to view this content.

It returns this:

	H	I	J	K	L	M	N
1			Days by month with wind Speed above 10
2
3		Hours		2015.12	2016.01	2016.02
4	1	2	1 to 2 hours	11	0	0	0
5	2	4	2 to 4 hours	1	0	0	0
6	4	6	4 to 6 hours	0	0	0	0
7	6	8	6 to 8 hours	0	0	0	0
8
9
10		Posted:		2015.12	2016.01	2016.02
11		Hours	1 to 2 hours	8
12			2 to 4 hours	1
13			4 to 6 hours	0
14			6 to 8 hours	0

[FDibbins]

OP has posted in the CS forum, so I am closing this thread now