Running count formula

cdburton — Sat, 10 Jun 2023 23:16:54 GMT

I have a column with data that is either a 0 or 1. I would like to have a running total down the table of the amount of times it is a 1 in a separate column. How do I do this?

Re: Running count formula

txnelson — Mon, 27 Jul 2020 21:43:53 GMT

All you need to do is create a new Formula Column, and use the Col Cumulative Sum() function

Create a new column
Go to the header of the new column, and right click and select "Formula"
In the formula, go to the left edge of the window to the List of function categories and click on "Statistical"
From the displayed list, select "Col Cumulative Sum()"
Now go to the list of columns and double click on the column you want to sum
Finally click on "OK"

topic Running count formula in Discussions

Running count formula

Re: Running count formula