#1   Report Post  
Posted to microsoft.public.excel.misc
TheHaze6990
 
Posts: n/a
Default Sum by color


Is there a way to sum a group of numbers by color?


--
TheHaze6990
Posted from - http://www.officehelp.in

  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default Sum by color

See

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

In article ,
TheHaze6990 wrote:

Is there a way to sum a group of numbers by color?

  #3   Report Post  
Posted to microsoft.public.excel.misc
Osprey
 
Posts: n/a
Default Sum by color

Just what I need but - tried it and get errors with #NAME? returned in the
function calling cell - any ideas?

SE

"JE McGimpsey" wrote:

See

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

In article ,
TheHaze6990 wrote:

Is there a way to sum a group of numbers by color?


  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Sum by color

Make sure you put the code in a general module--not behind a worksheet, not
behind ThisWorkbook.

Osprey wrote:

Just what I need but - tried it and get errors with #NAME? returned in the
function calling cell - any ideas?

SE

"JE McGimpsey" wrote:

See

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

In article ,
TheHaze6990 wrote:

Is there a way to sum a group of numbers by color?



--

Dave Peterson
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
My fill color and font color do not work in Excel Std Edition 2003 chapstick Excel Discussion (Misc queries) 1 September 11th 05 08:48 PM
Edit Color Palette Names SueDot Excel Discussion (Misc queries) 2 September 6th 05 03:51 PM
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
Color a cell and a value is automatically assigned to that color. Bossi Excel Worksheet Functions 0 May 3rd 05 05:45 AM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 04:45 AM


All times are GMT +1. The time now is 11:59 AM.

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"