Link to home
Create AccountLog in
Avatar of Flora Edwards
Flora EdwardsFlag for Sweden

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Phillip Burton
Phillip Burton

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Flora Edwards

ASKER

This is brilliant Philip

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.