Hi,
I'm looking for an excel formula that can count the months from the start of positive #s to the end of positive #s.
Zero values in between positive #s count.
Zero values do not count before the first positive # or after the last positive #.
I appreciate your time.
I'm looking for an excel formula that can count the months from the start of positive #s to the end of positive #s.
Zero values in between positive #s count.
Zero values do not count before the first positive # or after the last positive #.
Client | 5/31/2022 | 4/30/2022 | 3/31/2022 | 2/28/2022 | 1/31/2022 | 12/31/2021 | 11/30/2021 | 10/31/2021 | Formula Answer | |
A | 0 | 1 | 2 | 1 | 4 | 0 | 4 | |||
B | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 5 | ||
C | 0 | 6 | 1 | 0 | 0 | 0 | 0 | 2 | 7 |
Mr Excel
docs.google.com
I appreciate your time.
Last edited by a moderator: