Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif function by colors
Is there a way that I can sum up cells in column A by colors? For example,
suppose I have a list of numbers in cells A1:A15. Cells A1, A3, A5, and A10 are colored light yellow. I would like to see a number in cell B1 that sums up all cells in A1:A15 that are colored light yellow. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif function by colors
How did the cells attain their color?
If by Conditional Formatting simply sumif on that condition. If colored manually, you will need VBA User Defined Function to sumif by color. See Chip Pearson's site for info and code. http://www.cpearson.com/excel/colors.htm Gord Dibben MS Excel MVP On Tue, 5 Dec 2006 16:06:01 -0800, alm09 wrote: Is there a way that I can sum up cells in column A by colors? For example, suppose I have a list of numbers in cells A1:A15. Cells A1, A3, A5, and A10 are colored light yellow. I would like to see a number in cell B1 that sums up all cells in A1:A15 that are colored light yellow. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif function by colors
What is the formula if it were a conditional format?
"Gord Dibben" wrote: How did the cells attain their color? If by Conditional Formatting simply sumif on that condition. If colored manually, you will need VBA User Defined Function to sumif by color. See Chip Pearson's site for info and code. http://www.cpearson.com/excel/colors.htm Gord Dibben MS Excel MVP On Tue, 5 Dec 2006 16:06:01 -0800, alm09 wrote: Is there a way that I can sum up cells in column A by colors? For example, suppose I have a list of numbers in cells A1:A15. Cells A1, A3, A5, and A10 are colored light yellow. I would like to see a number in cell B1 that sums up all cells in A1:A15 that are colored light yellow. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif function by colors
See http://xldynamic.com/source/xld.CFConditions.html
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "alm09" wrote in message ... What is the formula if it were a conditional format? "Gord Dibben" wrote: How did the cells attain their color? If by Conditional Formatting simply sumif on that condition. If colored manually, you will need VBA User Defined Function to sumif by color. See Chip Pearson's site for info and code. http://www.cpearson.com/excel/colors.htm Gord Dibben MS Excel MVP On Tue, 5 Dec 2006 16:06:01 -0800, alm09 wrote: Is there a way that I can sum up cells in column A by colors? For example, suppose I have a list of numbers in cells A1:A15. Cells A1, A3, A5, and A10 are colored light yellow. I would like to see a number in cell B1 that sums up all cells in A1:A15 that are colored light yellow. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Using the TODAY() function in a SUMIF function | Excel Worksheet Functions | |||
Can I add and IF function to a SUMIF function? | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions |