View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kirk Bubul[_2_] Kirk Bubul[_2_] is offline
external usenet poster
 
Posts: 9
Default Add numbers if cell fill is a certain color; How To?

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.

Thanks in advance for your help.