| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing only the highlighed cells in a column
I am hightlighting certain items in a column(Dollar format). I need to sum
only the items that are highlighed. Is there a way to do this? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summing only the highlighed cells in a column
You can look at the resulting total in the status bar toward the right;
You can assign a name to the selection then use =SUM(ThatName) somewhere. "RJSads" wrote in message ... I am hightlighting certain items in a column(Dollar format). I need to sum only the items that are highlighed. Is there a way to do this? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summing only the highlighed cells in a column
if you want the sum in a cell, in that cell, type =sum( then start
<ctrlclicking the cells you want sum, and the references will be created "RJSads" wrote: I am hightlighting certain items in a column(Dollar format). I need to sum only the items that are highlighed. Is there a way to do this? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing all numeric values only in cells in a column | Excel Worksheet Functions | |||
| Remove/Ignore Letters when Summing cells in a column. | Excel Worksheet Functions | |||
| Summing cells within a column based on cell fill color | New Users to Excel | |||
| summing column c based an column a criteria | Excel Worksheet Functions | |||
| Excell prints in color, highlighed areas do not show up on screen | Excel Discussion (Misc queries) | |||
Linear Mode
