About
Pricing
Community
Teams
Start Free Trial
Log in
Flora Edwards
asked on
4/4/2017
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 Excel
Microsoft Office
10
1
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
Thank you very much.
Subodh Tiwari (Neeraj)
4/5/2017
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
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.