Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can you sum the last 5 columns of data from a range of data
I have a range of data that ranges from a3 to g43. Some of the range is empty
of data but I enter new data daily. So say the data is currently entered through row 15. Is there a way I can sum just the last 5 rows of entered data and have it update automatically whenever I add in a new row of data into the already established range? Hope that is clear enough. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Data Range | Excel Worksheet Functions | |||
Select updated data from a range of columns | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Data range properties | Excel Discussion (Misc queries) | |||
data range properties | Excel Discussion (Misc queries) |