# SumIf function in Excel

=?Utf-8?B?YXB3M2I=?=
Guest
Posts: n/a

 19th Jan 2005
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
Guest
Posts: n/a

 19th Jan 2005
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?
>
>

JE McGimpsey
Guest
Posts: n/a

 19th Jan 2005
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?

Valy Greavu
Guest
Posts: n/a

 19th Jan 2010
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 Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?SGFycnkgU2V5bW91cg==?= Microsoft Excel Worksheet Functions 9 12th Jun 2007 10:47 PM Fred Microsoft Excel Misc 2 29th Mar 2006 05:39 PM =?Utf-8?B?Qy5QZmx1Z3JhdGg=?= Microsoft Excel Worksheet Functions 5 31st Aug 2005 07:31 PM =?Utf-8?B?ZHNoaWdsZXk=?= Microsoft Excel Worksheet Functions 5 5th Apr 2005 03:34 AM Oscar Microsoft Excel Worksheet Functions 2 12th Jan 2005 12:01 AM

Features