Avatar of Flora Edwards
Flora Edwards
Flag 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.

thanks.
Book1.xlsx
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon
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
ASKER CERTIFIED SOLUTION
Subodh Tiwari (Neeraj)

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

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)

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

Can you please explain what the 9^9 is actually doing there?
Subodh Tiwari (Neeraj)

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

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)

You're welcome.
Flora Edwards

ASKER
Thank you very much.
Subodh Tiwari (Neeraj)

You're welcome Flora!
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes