Cumulative count skip 0

[Joe7745]

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

 

[Joe4]

Welcome to the Board!

I think you should be able to use the COUNTIF formula, with the criteria of ">0", to not count the cells with 0.
See: COUNTIF function

 

[Joe7745]

I tried that but then the issue is getting column 2 to automatically count with column 4 to continue cumulative counting.

 

[Joe4]

tried that but then the issue is getting column 2 to automatically count with column 4 to continue cumulative counting.

I don't really understood what you are saying.
Maybe have a COUNTIF for each column, and add the 2 COUNTIF formulas together?

Or, if looking for a cumulative count in column B of the data in columns A, assuming row 1 is the title row, you would place this formula in B2 and copy down for all rows:
=COUNTIF(A$2:A2,">0")

If I am way off base on what you are looking, please try to post an example. Many times seeing it is very beneficial in understanding what you are trying to do.
You can post images with the tool found here: XL2BB - Excel Range to BBCode

 

[Joe7745]

Ok this data comes from another sheet. I’d like The grads portion to cumulative count and leave the months with zero as a zero. This data constantly changes so the numbers can constantly change. I’m trying to find a formula that I won’t have to keep updating.

The data from the planned grads is the line going up on the chart. The bars come from the data I’m trying to cumulative count. The bars should eventually meet the line if we graduate what we planned. If we didn’t graduate someone in a month I need it zero. I probably just confused everyone. I appreciate the help.

 

[Joe4]

Those images are way too small and blurry for me to read.
I am just concerned about the formula, and not the chart itself. I assume if you get the formula working correctly, then the chart should be fine, as long as you have set it up correctly.

 

[Joe7745]

When I get home I’ll provide better details. My work blocks this site so I’m on my phone.