Choose Language Hide Translation Bar
Highlighted
cdburton
Level I

Running count formula

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?

1 REPLY 1
Highlighted
txnelson
Super User

Re: Running count formula

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

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