# Cumulative count skip 0

#### Joe7745

##### New Member
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”.

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

#### 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

##### New Member
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

##### New Member

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

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

Replies
1
Views
292
Replies
9
Views
125
Replies
10
Views
1K
Replies
3
Views
194
Replies
2
Views
183