Formula to find running totals

[bigband1]

Hello All
On the attached worksheet I have blocks of data sorted sequentially by date & name in cols a&c,col g is numeric data related to each block
of names.In col AI i wish to input the running total for each block of data in col G where the value is less than 5,the desired results are shown in col AI on the attached worksheet.Where no block of data has any value below 5 then zero.I have inserted an empty row between blocks for illustration,there are no empty rows in the data.This is a sample,the worksheet is much longer,and will be added to weekly.Many thanks for help given.

[Nisha Dhawan]

Hi Bigband - I have added a helper column and result is in column AK. please check and confirm if it works

[GC Excel]

Hello,

Try this formula in AI2 and copy down :

Please Login or Register  to view this content.

After, you can use a conditionnal formatting to remove the "duplicates" values within a same group with the following rule:
Select cell AI2 and apply the following condition on the column AI:

Please Login or Register  to view this content.

Change the font color to "white"