Flora Edwards
asked on
how to change this formula so that INDEX starts from C2 not C1
please see attached file.
i tried modifuing formula from
to
did not work.
how can i make this work so that it starts from C2 not C1
EE.xlsx
i tried modifuing formula from
=IF(C2=0,SUM(INDEX(C:C,MAX(IF($C$1:C1=0,ROW($C$1:C1)))+1):C1),"")
to
=IF(C2=0,SUM(INDEX(C2:C,MAX(IF($C$1:C1=0,ROW($C$1:C1)))+1):C1),"")
did not work.
how can i make this work so that it starts from C2 not C1
EE.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.