Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I use the sumif function with cell formatting as the criteria
I want to be able to add the values in a column of cells based on the color
formatting of that cell as the criteria. Is there a way to do that with sumif or is there some other function that will do that? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I use the sumif function with cell formatting as the criteria
Hi,
You can't use any of Excel's functions to sum based on color unless the color is itself applied based on a condition which you can enter in a regular formula. You can write a VBA function to sum based on color. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Dean" wrote: I want to be able to add the values in a column of cells based on the color formatting of that cell as the criteria. Is there a way to do that with sumif or is there some other function that will do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif function leaving a blank cell when criteria not met | Excel Worksheet Functions | |||
How do I use the SumIF function with a criteria of a cell color? | Excel Worksheet Functions | |||
Can I use two criteria in the SUMIF worksheet function? | Excel Discussion (Misc queries) | |||
Help with SUMIF function criteria | Excel Worksheet Functions | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |