Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Summing Cells by Color

Is there a Way to use the SumIf formula to Sum the Cells of a Certain Text
Color. For example i would like the cells that have a text color of red in a
certain column to be added up, and if the text of any other cell is that
column is changed to red it will automaticaly place it in the sum. If the
Sumif does not work is there another way i can use, i have little or no
progamming skills.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default Summing Cells by Color

Hi

What causes the cells to be Red?
Is it formatting where negative numbers are Red?
If so, then
=SUMIF(A:A,"<0")
If they are Red because of Conditional Formatting, then let us know the
formula you are using for the condition.
--
Regards
Roger Govier

"Dtemp" wrote in message
...
Is there a Way to use the SumIf formula to Sum the Cells of a Certain Text
Color. For example i would like the cells that have a text color of red in
a
certain column to be added up, and if the text of any other cell is that
column is changed to red it will automaticaly place it in the sum. If the
Sumif does not work is there another way i can use, i have little or no
progamming skills.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,420
Default Summing Cells by Color

See http://xldynamic.com/source/xld.ColourCounter.html

--
__________________________________
HTH

Bob

"Dtemp" wrote in message
...
Is there a Way to use the SumIf formula to Sum the Cells of a Certain Text
Color. For example i would like the cells that have a text color of red in
a
certain column to be added up, and if the text of any other cell is that
column is changed to red it will automaticaly place it in the sum. If the
Sumif does not work is there another way i can use, i have little or no
progamming skills.



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default Summing Cells by Color

See http://www.cpearson.com/Excel/colors.aspx for functions that return the
color indices of a range of cells (either background color or font color).
You can then use this function to perform "sum by color", "average by
color", and similar functions. The page contains all the code plus a
downloadable example.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)






"Dtemp" wrote in message
...
Is there a Way to use the SumIf formula to Sum the Cells of a Certain Text
Color. For example i would like the cells that have a text color of red in
a
certain column to be added up, and if the text of any other cell is that
column is changed to red it will automaticaly place it in the sum. If the
Sumif does not work is there another way i can use, i have little or no
progamming skills.


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Summing Cells by Color

Thank you for the help, hope the next version will auto refresh the numbers
as they are highleighted in a certain color instead of clicking F9 every time
:)

"Chip Pearson" wrote:

See http://www.cpearson.com/Excel/colors.aspx for functions that return the
color indices of a range of cells (either background color or font color).
You can then use this function to perform "sum by color", "average by
color", and similar functions. The page contains all the code plus a
downloadable example.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)






"Dtemp" wrote in message
...
Is there a Way to use the SumIf formula to Sum the Cells of a Certain Text
Color. For example i would like the cells that have a text color of red in
a
certain column to be added up, and if the text of any other cell is that
column is changed to red it will automaticaly place it in the sum. If the
Sumif does not work is there another way i can use, i have little or no
progamming skills.




  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,420
Default Summing Cells by Color

It doesn't.

--
__________________________________
HTH

Bob

"Dtemp" wrote in message
...
Thank you for the help, hope the next version will auto refresh the
numbers
as they are highleighted in a certain color instead of clicking F9 every
time
:)

"Chip Pearson" wrote:

See http://www.cpearson.com/Excel/colors.aspx for functions that return
the
color indices of a range of cells (either background color or font
color).
You can then use this function to perform "sum by color", "average by
color", and similar functions. The page contains all the code plus a
downloadable example.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)






"Dtemp" wrote in message
...
Is there a Way to use the SumIf formula to Sum the Cells of a Certain
Text
Color. For example i would like the cells that have a text color of red
in
a
certain column to be added up, and if the text of any other cell is
that
column is changed to red it will automaticaly place it in the sum. If
the
Sumif does not work is there another way i can use, i have little or no
progamming skills.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summing fields based on color neilh92064 Excel Discussion (Misc queries) 0 November 13th 07 08:39 PM
Color Cells Summing HANYANA Excel Worksheet Functions 29 January 10th 07 03:16 AM
Excel 2003 :Summing specific cells of a particular color in a colu FLYNNE Excel Discussion (Misc queries) 2 August 18th 06 10:50 PM
Excel 2003 will not display color fonts or color fill cells DaveC Excel Worksheet Functions 1 April 11th 05 04:38 PM
My excel 2003 wont let me fill cells with color or color the tabs. trizog New Users to Excel 2 February 22nd 05 07:43 PM


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"