Sum all values until the column is greater than 0

Reggie1995

Alright Crew - Here is the scenario.

I have this list of data. When the column 7D5B contains a zero, I need to sum the values on the left. So in the case of the image below, since there is a zero in rows 9-12, then I need to add the values in time diff together. I then need to do the same again for row 17, 21 and so on. Each time it list zero, I sum the rows together until that value is no longer zero. Thoughts here?

Workflow

Accepted answers

AngelosPachis

@Reggie1995

Like this?

Another multi-row formula tool was needed, which essentially will null a certain record from the Count field, if the next one in that column is not originally null... if that makes any sense

example.yxmd

All comments

Reggie1995

I don't think I can group by here because I don't want to sum all instances of zero into 1. Rather, each group of zeroes that are consecutive need to be grouped together.

AngelosPachis

Hi @Reggie1995 ,

If you want to group consecutive instances of zeroes together, then what about using a multi-row formula tool?

Is that the expected output?

Cheers,

Angelos

example.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703