Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 9th 05, 09:40 AM posted to microsoft.public.excel.worksheet.functions
MSOChick
 
Posts: n/a
Default Sum formula of cells with specific color value

Hello,
I am trying to ceate a SUM formula to add only the green filled
cells in a specified range. I am trying to do it with sum and
cell("color",reference) but I can't seem to be able to find color values. A
formula of: SUM(A3:E3) =CELL("color") simply returns a TRUE value. Any help
would be appreciated.

Thanks,
Lia

  #2   Report Post  
Old December 9th 05, 10:41 AM posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Sum formula of cells with specific color value

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MSOChick" wrote in message
...
Hello,
I am trying to ceate a SUM formula to add only the green filled
cells in a specified range. I am trying to do it with sum and
cell("color",reference) but I can't seem to be able to find color values.

A
formula of: SUM(A3:E3) =CELL("color") simply returns a TRUE value. Any

help
would be appreciated.

Thanks,
Lia



  #3   Report Post  
Old December 9th 05, 11:19 AM posted to microsoft.public.excel.worksheet.functions
MSOChick
 
Posts: n/a
Default Sum formula of cells with specific color value

Thanks so much! I found a VB that would counts the colors successfully, but
not when text or numbers were added to the cell.

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MSOChick" wrote in message
...
Hello,
I am trying to ceate a SUM formula to add only the green filled
cells in a specified range. I am trying to do it with sum and
cell("color",reference) but I can't seem to be able to find color values.

A
formula of: SUM(A3:E3) =CELL("color") simply returns a TRUE value. Any

help
would be appreciated.

Thanks,
Lia






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
highlight/color cells with specific character inside markx Excel Worksheet Functions 6 October 20th 05 10:19 AM
how to change a formula for a large group of cells Jen Excel Worksheet Functions 1 October 2nd 05 04:42 PM
Conditional formatting...cont. from 9/25 Guenzak Excel Discussion (Misc queries) 4 September 26th 05 10:55 PM
quick way to copy-paste a formula linked to cells in another file iniakupake Excel Worksheet Functions 2 September 26th 05 03:56 AM
Formula for counting specific cells which are greater than 1 mmock Excel Discussion (Misc queries) 0 April 26th 05 03:03 AM


All times are GMT +1. The time now is 06:42 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017