Solved

# Formula in Excel

Posted on 2004-04-27
Medium Priority
208 Views
Hi,

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.

0
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:

=SUM(DATA_RANGE)

~ Ranjeet Rain

0

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
=sum(E1:E68536)
0

## Featured Post

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.