counting the number of wet days followed by wet days and wet days by dry days in rainfall

**k6milan** · 09-12-2020, 07:05 AM

Hi, I want to know the excel formula to count the number for
a) wet days followed by wet days
b) wet days followed by dry days
in the long term daily rainfall data.
please see the attached excel file which explains what I need and expected results.
assumption: any days (value in column B in example file>0) rainfall is wet days.
any days (value in column B in example file=0) is dry days.

**Bo_Ry** · 09-12-2020, 08:09 AM

Please try at
J3
=LEN(SUBSTITUTE(CONCAT(N(B4:B34>0)),11,119))-COUNT(B4:B34)

J4
=LEN(SUBSTITUTE(SUBSTITUTE(CONCAT(N(B4:B34>0)),11,22),10,109))-COUNT(B4:B34)

**k6milan** · 09-12-2020, 11:03 AM

Hi Bo_Ry, Thank you so much, The formula works now.

counting the number of wet days followed by wet days and wet days by dry days in rainfall

LinkBack

Thread Tools

Rate This Thread

Display

counting the number of wet days followed by wet days and wet days by dry days in rainfall

Re: counting the number of wet days followed by wet days and wet days by dry days in rainf

Re: counting the number of wet days followed by wet days and wet days by dry days in rainf

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Roster: calculate the work days between 2 off days if it is more than 5 days.

find Sum of # of days w/o counting overlapping days twice with multiple paramaters

[SOLVED] calculate total number of days between two days based on 365 days year

[SOLVED] How to find Sum of # of days w/o counting overlapping days twice

How to calculate number of sick days taken in a rolling 365 days period based on colour

[SOLVED] Number of days till.. Formula for counting number of days

Counting the days worked and days remaining on a schedule automatically

Bookmarks

Bookmarks

Posting Permissions