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”.