Forum

Notifications
Clear all

How to count number of days greater than

2 Posts
2 Users
0 Reactions
73 Views
(@tex-walsch)
Posts: 1
New Member
Topic starter
 

I am trying to get the formula that should the year equal 1994 and the month equals 1 then count the number of days greater than 10. In the attached file in cell I3 I have entered the following formula =IF(AND(G3=$A$2:$A$366,$B$2:$B$366=Y1),COUNTIF($D$2:$D366,">10"),0) but get the answer 21.

 
Posted : 26/06/2018 9:35 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Tex

See if this helps. I assuming >10 is the rain fall.

Sunny

 
Posted : 26/06/2018 10:46 pm
Share: