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.