Flora Edwards

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

thanks.

Book1.xlsx

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

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.

ASKER

Thank you very much.

You're welcome Flora!

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