Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Laura
 
Posts: n/a
Default I can't figure out how to add values based on font color.

I'm trying to add values in a chart based on color only - for example, I've
put charge card purchases in blue and debit card purchases in green, and
would like my totals at the bottome of the spreadsheet to add all of the
credit card purchases, and then all of the debit card purchases. This is
hard to explain in words, I hope someone can help.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech
 
Posts: n/a
Default I can't figure out how to add values based on font color.

You would make it much simpler just by adding a Chrg/Dbt column and then use
SumIf to sum each type.

--
Jim
"Laura" wrote in message
...
| I'm trying to add values in a chart based on color only - for example,
I've
| put charge card purchases in blue and debit card purchases in green, and
| would like my totals at the bottome of the spreadsheet to add all of the
| credit card purchases, and then all of the debit card purchases. This is
| hard to explain in words, I hope someone can help.


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
list two columnar values based on conditional formating (text color) beechum1 Excel Worksheet Functions 2 February 12th 06 10:53 AM
Return Range of Numerical Values in Single Column based on Frequency Percentage Sam via OfficeKB.com Excel Worksheet Functions 9 October 29th 05 12:01 AM
FONT COLOR FORMAT JMCA2000 Excel Discussion (Misc queries) 6 August 23rd 05 08:48 AM
Excel 2003 Font Color and Background Color DrankPA6 Excel Discussion (Misc queries) 1 August 13th 05 12:43 AM
I have cells with diffent color fonts and need to total based on . KyaraB Excel Discussion (Misc queries) 1 April 20th 05 06:28 PM


All times are GMT +1. The time now is 01:27 AM.

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

About Us

"It's about Microsoft Excel"