Link to home
Start Free TrialLog in
Avatar of Flora Edwards
Flora EdwardsFlag for Sweden

asked on

how to change this formula so that INDEX starts from C2 not C1

please see attached file.

i tried modifuing formula from
=IF(C2=0,SUM(INDEX(C:C,MAX(IF($C$1:C1=0,ROW($C$1:C1)))+1):C1),"")

Open in new window


to
=IF(C2=0,SUM(INDEX(C2:C,MAX(IF($C$1:C1=0,ROW($C$1:C1)))+1):C1),"")

Open in new window


did not work.

how can i make this work so that it starts from C2 not C1
EE.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial