Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Cells by Color
Is there a Way to use the SumIf formula to Sum the Cells of a Certain Text
Color. For example i would like the cells that have a text color of red in a certain column to be added up, and if the text of any other cell is that column is changed to red it will automaticaly place it in the sum. If the Sumif does not work is there another way i can use, i have little or no progamming skills. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Cells by Color
Hi
What causes the cells to be Red? Is it formatting where negative numbers are Red? If so, then =SUMIF(A:A,"<0") If they are Red because of Conditional Formatting, then let us know the formula you are using for the condition. -- Regards Roger Govier "Dtemp" wrote in message ... Is there a Way to use the SumIf formula to Sum the Cells of a Certain Text Color. For example i would like the cells that have a text color of red in a certain column to be added up, and if the text of any other cell is that column is changed to red it will automaticaly place it in the sum. If the Sumif does not work is there another way i can use, i have little or no progamming skills. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Cells by Color
See http://xldynamic.com/source/xld.ColourCounter.html
-- __________________________________ HTH Bob "Dtemp" wrote in message ... Is there a Way to use the SumIf formula to Sum the Cells of a Certain Text Color. For example i would like the cells that have a text color of red in a certain column to be added up, and if the text of any other cell is that column is changed to red it will automaticaly place it in the sum. If the Sumif does not work is there another way i can use, i have little or no progamming skills. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Cells by Color
See http://www.cpearson.com/Excel/colors.aspx for functions that return the
color indices of a range of cells (either background color or font color). You can then use this function to perform "sum by color", "average by color", and similar functions. The page contains all the code plus a downloadable example. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Dtemp" wrote in message ... Is there a Way to use the SumIf formula to Sum the Cells of a Certain Text Color. For example i would like the cells that have a text color of red in a certain column to be added up, and if the text of any other cell is that column is changed to red it will automaticaly place it in the sum. If the Sumif does not work is there another way i can use, i have little or no progamming skills. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Cells by Color
Thank you for the help, hope the next version will auto refresh the numbers
as they are highleighted in a certain color instead of clicking F9 every time :) "Chip Pearson" wrote: See http://www.cpearson.com/Excel/colors.aspx for functions that return the color indices of a range of cells (either background color or font color). You can then use this function to perform "sum by color", "average by color", and similar functions. The page contains all the code plus a downloadable example. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Dtemp" wrote in message ... Is there a Way to use the SumIf formula to Sum the Cells of a Certain Text Color. For example i would like the cells that have a text color of red in a certain column to be added up, and if the text of any other cell is that column is changed to red it will automaticaly place it in the sum. If the Sumif does not work is there another way i can use, i have little or no progamming skills. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Cells by Color
It doesn't.
-- __________________________________ HTH Bob "Dtemp" wrote in message ... Thank you for the help, hope the next version will auto refresh the numbers as they are highleighted in a certain color instead of clicking F9 every time :) "Chip Pearson" wrote: See http://www.cpearson.com/Excel/colors.aspx for functions that return the color indices of a range of cells (either background color or font color). You can then use this function to perform "sum by color", "average by color", and similar functions. The page contains all the code plus a downloadable example. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Dtemp" wrote in message ... Is there a Way to use the SumIf formula to Sum the Cells of a Certain Text Color. For example i would like the cells that have a text color of red in a certain column to be added up, and if the text of any other cell is that column is changed to red it will automaticaly place it in the sum. If the Sumif does not work is there another way i can use, i have little or no progamming skills. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing fields based on color | Excel Discussion (Misc queries) | |||
Color Cells Summing | Excel Worksheet Functions | |||
Excel 2003 :Summing specific cells of a particular color in a colu | Excel Discussion (Misc queries) | |||
Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel |