Find last number in column and calculate %

Hi,
I am helping someone with a worksheet and he has a column of numbers that add to a total and then calculates a % of the total from the new number.
Right now, he has to change the formula each time to capture the new number he enters.
Here is a sample file.
Your help is appreciated.
Find-last-value-and-subtract---s.xlsx
Johnette ConnelleyBudget Analyst / ProjectsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
NBVCConnect With a Mentor Commented:
Try:

=SUM(A2-LOOKUP(10^10,A:A))/A2
0
 
barry houdiniCommented:
....although you don't really need SUM function - try

=1-LOOKUP(10^10,A:A)/A2

regards, barry
0
 
Johnette ConnelleyBudget Analyst / ProjectsAuthor Commented:
That is excellent!  Thanks so much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.