Link to home
Start Free TrialLog in
Avatar of Patrick O'Dea
Patrick O'DeaFlag for Ireland

asked on

Inherited sheet - How do I make "total line" move dynamically

See this video which explains all in 30 seconds.
http://screencast.com/t/u8q0bP3VyiPD

I have been given a sheet and asked if I can replicate the functionality.
Specifically, there is a total line in a sheet.  
When I drag the details lines to expand the range then the total also moves down.

The video explains it best.
How do I achieve this?
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Patrick O'Dea

ASKER

Thanks Roy,

I just got it !

it is a table and the "Design" tab allows a total function which achieves this effect.
Glad to help

You can change the Functions in the Total Row for SUM, COUNT etc. Click in the cell and a drop down appears
Avatar of Arana (G.P.)
Arana (G.P.)

its just a table with  a total row
select some data in your sheet, and go to home tab and format as table, go to the last row and go to design tab and select TOTAL ROW
now yo0u can scroll/fill your values in last column and thats what you want