| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sum up values only in cells that are color filled?
Can anyone help me further with this issue? I want to add up cells dependent
on colour - but all of the information on the links looks very complicated and I don't know how to implement the codes. Is there a really simple guide to doing this? usually I will have a go at anything, but this stumps me. -- Thanks Michele "Ron Rosenfeld" wrote: On Wed, 5 Jan 2005 23:11:01 -0800, "TryingExcel" wrote: Each cell that filled with "red" represents player A, "blue" player B, etc. In each cell is also a score (some value). I want to total the scores for player A (the values in all the red cells) and player B (the values in all the "blue" cells), etc. How does the cell get filled with a color? If the color is there because of conditional formatting, then you will need to use the same formula in your SUM(scores) formula. Something like =SUMPRODUCT((Player="A")*Scores) --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| Formatting cells in Excel for certain Values to appear certain Col | Excel Worksheet Functions | |||
| delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
| How to add a button to restore all altered cells original values? | Excel Discussion (Misc queries) | |||
| calculate the sum of cells where values are between 6 and 10 in e. | Excel Worksheet Functions | |||
Threaded Mode
