Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
show the sum of an arbitary selection of cells
I want to select an arbitary number of cells on my worksheet then show the
sum of those cells in real time in another cell, say display result in F5 cell, then if I select another set of cells then F5 update with sum of the newly selected cells. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
show the sum of an arbitary selection of cells
Bob,
When you select more than one cell, the sum of the cells appears in the status bar at the bottom of the window. It should appear in the largest of the rectangles in the lower right-hand corner. If it does not, or if it is showing a different function, right-click on the box and select Sum. If you wanted such functionality on the sheet itself, you would need a macro. Tim C "Bob Oxley" <Bob wrote in message ... I want to select an arbitary number of cells on my worksheet then show the sum of those cells in real time in another cell, say display result in F5 cell, then if I select another set of cells then F5 update with sum of the newly selected cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked cells show wrong number | Links and Linking in Excel | |||
Show the defined name of cells, help with modification of this UDF | Excel Worksheet Functions | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
How do I shade cells during selection? | Excel Worksheet Functions | |||
How do I freeze or lock cells to show up on each page without typ. | Excel Discussion (Misc queries) |