show the sum of an arbitary selection of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to add numbers in same cell? 2
Copy data from the Status Bar 3
Summing across multiple worksheets in excel 2007 3
Using the answer IF "true" in another formula? 1
How can I copy the sum of a filtered column into a cell in anothe 1
Conditional Sum across WORKSHEET 6
Excel Sum numbers in cells that also contain text 34
Copy Data from Within same Workbook 1

Back
Top