| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding specific cells
My spreadsheet has numbers in cells B2 to B30. I have used a cell pattern
color in various cells to identify the cells that I would like to sum. Cell B31 represents the total sum of the cells that have a pattern color. Is there a formula (for B31) or a method to automate adding the shaded cells? If this is not possible do you have any other suggestions to identify certain cells and total the sum of only the identified cells? Thanks in advance. -- Shooter |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding specific cells
See http://www.xldynamic.com/source/xld.ColourCounter.html for a solution.
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Shooter" wrote in message ... My spreadsheet has numbers in cells B2 to B30. I have used a cell pattern color in various cells to identify the cells that I would like to sum. Cell B31 represents the total sum of the cells that have a pattern color. Is there a formula (for B31) or a method to automate adding the shaded cells? If this is not possible do you have any other suggestions to identify certain cells and total the sum of only the identified cells? Thanks in advance. -- Shooter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find cells that contain specific characters | Excel Worksheet Functions | |||
| highlight/unhighlight (or color/uncolor) cells containing a specific character | Excel Worksheet Functions | |||
| Adding cells with specific colors | Excel Discussion (Misc queries) | |||
| Showing zero in specific cells | Excel Discussion (Misc queries) | |||
| print specific cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
