Find last number in column and calculate %

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.
Johnette ConnelleyBudget Analyst / ProjectsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

NBVCConnect With a Mentor Commented:

barry houdiniCommented:
....although you don't really need SUM function - try


regards, barry
Johnette ConnelleyBudget Analyst / ProjectsAuthor Commented:
That is excellent!  Thanks so much!
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.