sum formula with automatic action

[arifanmol]

I need a formula that automatically sums up area of cells from first cell to last cell
but it should be noted that if cells are increased or decreased the sum formula be automatically changed and carry out the sum
(for now we require to do it manually using sum formula)
is there any formula plz

 

[pecoflyer]

Make your range an Excel Table and sum as usual. Excel will add structured reference on the fly

 

[arifanmol]

Can you exemplify plz

 

[AVK]

Firstly restructure sheet see attachment
Go to formula tab > Name manager > new > Enter name as data1 > refers to give range =Sheet1!$D:$D
same for other table.
=sum(data1) in another column.

 

[arifanmol]

This way we may require to generate various data tables is there no way to automatically fly the sum formula continually whether the ce;lls increase or de

 

[arifanmol]

is there any way to automatically sum the cells and with automatic change in data range as the cells decrease or increase

 

[arifanmol]

can we have the formula that argues : if the text 'total' in in this particualar cell then

put sum of cell right above 'total' cell and B3

 

[pecoflyer]

Can you exemplify plz

Please read the provided link to solve your problem

 

[arifanmol]

but after formation of table how should it be utilized so that my above referred query and requirement can be addressed

 

[bosco_yip]

but after formation of table how should it be utilized so that my above referred query and requirement can be addressed

No, Excel is using top-down calculation way, you cannot put total on top of data if you are using Excel Tables.

Otherwise

you need VBA to do the automatic work in meet with your requirement,

and

you need re-submit your question to our VBA Marcos forum.

This post is closed.

Regards