Joe7745
New Member
- Joined
- May 22, 2020
- Messages
- 4
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
- MacOS
I’m trying to do a cumulative count but I want it to skip columns with 0.
example column 1 (October) has 0, column 2 (September) has 6, column 3 (November) has 0 and column 4 (December) has 5.
I want it to cumulative count but not add a number in the zero column. This data goes on a chart so I want that month to remain 0 but cumulative count the months greater than zero. The data will constantly change so the formula needs to account for the columnpossibly not being zero but if it were not to cumulative count.
The chart uses a bar graph which intersect with a line graph. The line graph is the number we should graduate each month, the bar is actual grads. It needs to cumulative count to see when we “catch back up”.
example column 1 (October) has 0, column 2 (September) has 6, column 3 (November) has 0 and column 4 (December) has 5.
I want it to cumulative count but not add a number in the zero column. This data goes on a chart so I want that month to remain 0 but cumulative count the months greater than zero. The data will constantly change so the formula needs to account for the columnpossibly not being zero but if it were not to cumulative count.
The chart uses a bar graph which intersect with a line graph. The line graph is the number we should graduate each month, the bar is actual grads. It needs to cumulative count to see when we “catch back up”.