Formula for counting rain days of the year, month, and or week

Originally Posted by FDibbins

See if this works for you...
G6=COUNTIFS(C:C,">0",A:A,">="&DATE(F6,1,1),A:A,"<="&DATE(F6,12,31))
I6=COUNTIFS(C:C,">0",A:A,">="&DATEVALUE(1&H6),A:A,"<"&EDATE(DATEVALUE(1&H6),1))
for the week num, I used a helper that you can hide if needed...
D3=WEEKNUM(A3)&", "&YEAR(A3)
copied down

then I changed J6 etc to just 1, 2015
K6=COUNTIFS(C:C,">0",D:D,J6)

Hi FDibbins,

It is not counting as days. I think it is counting the 30mins interval of the data not days.

for years, it is counting more than 365 days, for the month it is counting more than 31, and for the week more than 7.

Regards,
Dean