I have a table with date in column A and amount of rainfall in column B. In column C I need to count if there is an occurrence of rainfall over 2 inches in a consecutive two day period. If the rainfall does exceed 2 inches it is counted and the calculation starts over for the subsequent days. [if on Monday it rained .5 inches, on Tuesday 1.65 inches then a count (1) is entered in column C for Tuesday. On Wednesday if it rained .60 inches the calculation recycles and does not use the rainfall on Tuesday because it was previously used in the previous two day total calculation. So Wednesday would not qualify as an occurrence of rainfall over a two day period.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Count the occurrences of rainfall over 2 inches within a two day period.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,974
- Office Version
- 365
- Platform
- Windows
Duplicate: Count the occurrences of rainfall over 2 inches within a two day period.
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).
Upvote
0
- Status
Similar threads
- Question
- Question
