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 |
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 |
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 |
All times are GMT +1. The time now is 01:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com