Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 46
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 130
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
counting entries within a cell's formula Mark Excel Worksheet Functions 8 March 14th 07 06:43 PM
Toolbar@bottom used to show sum when I highlited cells-now gone! Carmen Excel Discussion (Misc queries) 1 March 22nd 06 02:22 PM
How do I use a referenced cell's formula instead of formula output? Farrelltw Excel Worksheet Functions 0 February 10th 06 05:00 PM
How do I use a cell's text, "A1", and put it in a formula? HighRiser Excel Worksheet Functions 1 July 6th 05 04:11 PM
Formula that will allow you to add one to cell's value by clickin. lb Excel Worksheet Functions 1 April 21st 05 06:20 PM


All times are GMT +1. The time now is 10:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"