Hi Kirk,

Am Fri, 15 Feb 2013 09:33:06 -0600 schrieb Kirk Bubul:

Being old, I keep a spreadsheet of all medical events and their
eventual payments to medical providers. This year we have one
major category of outgo with numerous events. The amounts I'd
like to single out and sum are scattered throughout the rows of
Column G.

Can I use a unique fill color for all the expense amount cells
that I'd like to sum and then do a function that would add
together only the amounts in these colored cells? If so, please
tell me the formula.

you can add numbers by value, e.g. add all numbers greater 50:
=SUMIF(G2:G100,"50")
You also can highlight the numbers you want to add, then filter by color
and sum with:
=SUBTOTAL(9,G2:G100)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2