SumIf function in Excel

's Computer Specifications

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?

's Computer Specifications

http://www.cpearson.com/excel/colors.htm

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"apw3b" <(E-Mail Removed)> wrote in message
news:4C02142B-52A5-45F8-BEB7-(E-Mail Removed)...
> 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?
>
>

's Computer Specifications

See

http://cpearson.com/excel/colors.htm

In article <4C02142B-52A5-45F8-BEB7-(E-Mail Removed)>,
"apw3b" <(E-Mail Removed)> 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?

's Computer Specifications

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?
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"	=?Utf-8?B?SGFycnkgU2V5bW91cg==?=	Microsoft Excel Worksheet Functions	9	12th Jun 2007 10:47 PM
Sumif of Sumif perhaps?	Fred	Microsoft Excel Misc	2	29th Mar 2006 05:39 PM
Embedding a Sumif in a sumif	=?Utf-8?B?Qy5QZmx1Z3JhdGg=?=	Microsoft Excel Worksheet Functions	5	31st Aug 2005 07:31 PM
nested sumif or sumif with two criteria	=?Utf-8?B?ZHNoaWdsZXk=?=	Microsoft Excel Worksheet Functions	5	5th Apr 2005 03:34 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function	Oscar	Microsoft Excel Worksheet Functions	2	12th Jan 2005 12:01 AM