Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
list two columnar values based on conditional formating (text color) | Excel Worksheet Functions | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
FONT COLOR FORMAT | Excel Discussion (Misc queries) | |||
Excel 2003 Font Color and Background Color | Excel Discussion (Misc queries) | |||
I have cells with diffent color fonts and need to total based on . | Excel Discussion (Misc queries) |