Count if formula with nested components... please help

[Joe Spamalot]

Hello saviour

I'm a bit of a novice in excel and have been racking my brain and the internet on this one. Here's the data set

B Rain days	C Apr	D May	E Jun	F Jul	G Aug	H Sep
We	0			0
Th	0			0.2
Fr	0	0		0.8
Sa	0	0		0.3	0
Su	0	0		3.4	0
Mo	0	3.4	0	0.8	0
Tu	10	0.4	9.6	7.6	0	4
We	4	0	0.8	16	0	0
Th	1	0	0.6	0.1	0	0
Fr	14.6	0	0.1	3	0.4	0
Sa	3.8	0	1.4	0.1	15	10.4
Su	9.2	0	0.3	0	6.8	1.2
Mo	0.8	0	0.4	0	1.4	0
Tu	0.2	0	0	0	3.4	0
We	0.4	0	0	0	0	0
Th	0	0	0	0	0.2	0
Fr	0	0	0.6	0	5.4	6.3
Sa	0	10.2	0	2.3	0	18
Su	0	21.8	0	1.2	0	4.4
Mo	0	29.6	0	30.7	11.2	0
Tu	0	0.1	0	10.4	5.8	0.3
We	0	0	0	1.4	0.1	0
Th	0	0	2.8	10.4	20.8	0
Fr	0	0	4.6	0.1	4.2	0
Sa	0	0	5.7	0.1	14.2	0.8
Su	0	0.6	16.3	0.1	0.1	0
Mo	0	0	10.4	0	0.2	0
Tu	0	0.2	0.1	1.4	0	0
We	0	0	0	2	0	0
Th	0.1	0	0	4.2	0	0
Fr		0	0	7.4	2.4	0
Sa		0	0.1		1.8	0
Su		0	0		12.2	0
Mo			0		1	0
Tu			0			0
We						0
Totals	44.1	66.3	53.8	104	106.6	45.4
number of rain days	10	8	15	23	19	8
Average of rain days	4.4	8.3	3.6	4.5	5.6	5.7
Wet days	0

<tbody>
</tbody>

The formula which is returning a 0 in Wet days is:

=COUNTIF(C16:C51, VLOOKUP( OR("Mo", "Tu", "We", "Th", "Fr"),B16:H51, 2, FALSE) >C54)

What I want is to add up the number of rain days that occurred on a week day that was above the average for the rain days in that month

Help greatly appreciated

Cheers

Joe

 

[Joe Spamalot]

Found the solution to this if it helps anyone else. It is

=SUM(COUNTIFS($A$2:$A$37,{"Mo","Tu","We","Th","Fr"},B2:B37,">"&B40))

Cheers

Joe