Notifications
Clear all
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
Hi Tex
See if this helps. I assuming >10 is the rain fall.
Sunny
Posted : 26/06/2018 10:46 pm