ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   can I do a formula to use only the highlited cell's (https://www.excelbanter.com/excel-worksheet-functions/141886-can-i-do-formula-use-only-highlited-cells.html)

ekkeindoha

can I do a formula to use only the highlited cell's
 
I would like to know if possible that when I highlite row 22 upto 34, only
the cell's in these rows will be added.

Ronald Dodge[_2_]

can I do a formula to use only the highlited cell's
 
If you have the status bar showing, you can right click on it in the middle
to a bit on the right side from the middle, and then click on "SUM". If the
status bar is not showing, to have it shown, click on View, Status Bar

This will show the sum of the values of those selected cells in the status
bar as you highlight cells.

Ronald R. Dodge, Jr.
Master MOUS 2000

"ekkeindoha" wrote in message
...
I would like to know if possible that when I highlite row 22 upto 34, only
the cell's in these rows will be added.





All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com