Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif
Can cell be totaled (added together) using the backround color as the
criteria for choosing the cells in a sumif command? Example, add all cells with the red backround color. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif
See this:
http://cpearson.com/excel/colors.htm In my opinion, you're better off using the logic of why the cells are a certain color to construct a formula with the built-in functions. For example, the cells are red because the values are less than 100. Then it could be as easy as: =SUMIF(A1:A10,"<100") Biff "Fk" wrote in message ... Can cell be totaled (added together) using the backround color as the criteria for choosing the cells in a sumif command? Example, add all cells with the red backround color. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif
The color of the cell and the value of the cell aren't related. I also need
to know where can get the numerical value of the cell colors. Thanks "Fk" wrote: Can cell be totaled (added together) using the backround color as the criteria for choosing the cells in a sumif command? Example, add all cells with the red backround color. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif
That's covered at the link. Look for: Returning The ColorIndex Of A Cell
Biff "Fk" wrote in message ... The color of the cell and the value of the cell aren't related. I also need to know where can get the numerical value of the cell colors. Thanks "Fk" wrote: Can cell be totaled (added together) using the backround color as the criteria for choosing the cells in a sumif command? Example, add all cells with the red backround color. |
Reply |
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 | |||
How to use SUMIF function with non-adjacent cells | Excel Worksheet Functions | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
SUMIF | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions |