| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
SumIf function in Excel
How do I obtain the sum of cell range that uses the font color as the 'if'
criteria? I have tried the following; =SUMIF(F3:F6,"Font.ColorIndex = 3") but this does not work. Has anyone a solution? |
|
#2
|
|||
|
|||
|
http://www.cpearson.com/excel/colors.htm
-- Kind Regards, Niek Otten Microsoft MVP - Excel "apw3b" wrote in message ... How do I obtain the sum of cell range that uses the font color as the 'if' criteria? I have tried the following; =SUMIF(F3:F6,"Font.ColorIndex = 3") but this does not work. Has anyone a solution? |
|
#3
|
|||
|
|||
|
See
http://cpearson.com/excel/colors.htm In article , "apw3b" wrote: How do I obtain the sum of cell range that uses the font color as the 'if' criteria? I have tried the following; =SUMIF(F3:F6,"Font.ColorIndex = 3") but this does not work. Has anyone a solution? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumIf function in Excel
Try this:
This is a Romanian version of SumIf by Colors. http://valygreavu.wordpress.com/2010...ful-solutions/ -- Valy Greavu MVP, MCP, MOS, TS http://valygreavu.wordpress.com/ "apw3b" wrote: How do I obtain the sum of cell range that uses the font color as the 'if' criteria? I have tried the following; =SUMIF(F3:F6,"Font.ColorIndex = 3") but this does not work. Has anyone a solution? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| sumif function in excel | Excel Worksheet Functions | |||
| Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions | |||
Hybrid Mode
