# 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.

thanks.
Book1.xlsx
Lee Ingalls

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.
calc.jpg
Subodh Tiwari (Neeraj)

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.