Restart a Count within a Column

**cookthebooks80** · 07-03-2014, 12:11 PM

count test.xlsxI tried searching for the answer previously, but wasn't having much luck with my syntax, so apologies in advance if I overlooked an existing answer here.

I have three columns of data: date of observation, level of observation, and a 1 or 0 depending on whether or not the level of observation exceeds a certain threshold. I am struggling to figure out how to do a running count of the number of 1s in the column that resets and restarts whenever a 0 observation occurs. any insights would be greatly appreciated!

**zbor** · 07-03-2014, 12:14 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**cookthebooks80** · 07-03-2014, 12:33 PM

thanks for the advice! prior post edited to include sheet.

**aydeegee** · 07-06-2014, 11:46 AM

Hi cookthebooks80

Welcome to the forum

The formula in the attached sheet seems to work.

Regards
Alastair

Restart a Count within a Column

LinkBack

Thread Tools

Rate This Thread

Display

Restart a Count within a Column

Re: Restart a Count within a Column

Re: Restart a Count within a Column

Re: Restart a Count within a Column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Restart Line Count if Value Changes in Seperate Cell

[SOLVED] Restart and increment numbers in column based on changed value in adjacent column

count sessions then restart 365 days after - help

Count to "X", then restart count at "1"

[SOLVED] 'Do Until...' Restart

Bookmarks

Bookmarks

Posting Permissions