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

Microsoft ExcelMicrosoft Office

Last Comment

Subodh Tiwari (Neeraj)

8/22/2022 - Mon

Lee Ingalls

4/4/2017

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

ASKER CERTIFIED SOLUTION

Subodh Tiwari (Neeraj)

4/4/2017

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Arana (G.P.)

4/4/2017

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.

Subodh Tiwari (Neeraj)

4/4/2017

Thanks Arana! Glad you found it useful. :)

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!

James Murphy

Arana (G.P.)

4/4/2017

Can you please explain what the 9^9 is actually doing there?

Subodh Tiwari (Neeraj)

4/4/2017

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.

Arana (G.P.)

4/4/2017

Get it now, thank you.

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

Subodh Tiwari (Neeraj)

4/4/2017

You're welcome.

Flora Edwards

4/5/2017

ASKER