ExcelBanter - SumIf function in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SumIf function in Excel (https://www.excelbanter.com/excel-worksheet-functions/9477-sumif-function-excel.html)

apw3b

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?

Niek Otten

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?

JE McGimpsey

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?

Valy Greavu

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?

All times are GMT +1. The time now is 12:01 PM.