Formula in Excel

Posted on 2004-04-27
Medium Priority
Last Modified: 2010-04-17

How do i create formula in excel for the following case,

There are two columns (Supplier Name & Due Amount), population of this data will be
from row 3. In my first row i need to display the total due amount, so i need to create formula
for this. When i add new supplier & due amount at the end, now my total amount should get changed, formula should not be changed now. I can even delete a supplier.

Question by:ganesh_82in
LVL 19

Accepted Solution

RanjeetRain earned 252 total points
ID: 10936352
The best thing in your scenario is a NAMED RANGE. Create a forlmula based on a name range rather than by directly refrencing the cell addresses. YOur formula could look like:


~ Ranjeet Rain

LVL 10

Assisted Solution

anv earned 248 total points
ID: 10937132
u can use formula like..

say is the column for due amount in E then

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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.

Join & Write a Comment

The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
No other job is as rewarding and demanding as building an iPhone app is. It is not really in the hands of the developer for the success of an iPhone app. Many factors operate jointly for every iOS application's success in the market.
Six Sigma Control Plans

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question