Excel Easy Formula help
please see the attached file. there are two tables, table1 which is what i have current. Table2 is what i need.
might be very easy, but i could not figure it out.
EE.xlsx
might be very easy, but i could not figure it out.
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.
ASKER
wouldn't it be possible to do this via the original formula? with INDEX and ROW?
if this is too much trouble, then i can live with =IF(A5=A4,SUM(B5,C4),B5)
thanks very much.