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

asked on

simple SUM formula but cannot get my head around it how to solve it.

please see attached. how can i put a single formula in G2 and drag down and it will work just like it is shown in Column G.

Avatar of Lee Ingalls
Lee Ingalls
Flag of United States of America image

Is column G the SUM of column 1 & column F?
Add you calculation then drag it down...

You may have to populate column A with the values of each section; otherwise it will use A2 for each.
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Arana (G.P.)
Arana (G.P.)

good one Neeraj, I'm sure I have needed this many times and i've come with a number of ways to do it but none of the so clean and tidy.
Thanks Arana! Glad you found it useful. :)
Can you please explain what the 9^9 is actually doing there?
9^9 returns just a large number which is not supposed to be in lookup column and with match_type with True, Match finds the last number in the lookup column.
Get it now, thank you.
You're welcome.
Avatar of Flora Edwards


Thank you very much.
You're welcome Flora!