Sum value on long cohort size

[TrungVL]

I got a cohort follow this google sheet

https://docs.google.com/spreadsheets/d/1sPwOg_YIVQ_b0IN7q3bQHyfRKQ42MA4ayfP77HpkvGs/edit#gid=0


I wanted to sum the value like some of example listed, this could be done with simple forumla and short cohort.
But if the cohort length is too long, I don't know what to do.


For example: Sum value for Day7 from 9/17-> 9/23 -> sum last value up to seven days of each days.

 

[AlanY]

Re: Sum value on long cohhort size

try this in A2 and copy down

=SUMPRODUCT((ROW($C$2:$AF$32)-MIN(ROW(C2:AF32))=MIN(COLUMN(C2:AF32))-COLUMN($C$2:$AF$32))*($C$2:$AF$32))