Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do i auto fill cell color based on other cells' color? | Excel Programming | |||
How can I sum numbers that have a gray color-fill in cell? | Excel Discussion (Misc queries) | |||
Average numbers by fill color | Excel Discussion (Misc queries) | |||
Match TextBox Back Color to Cell Fill Color | Excel Programming | |||
change fill color of a range of cells based on color of a cell? | Excel Programming |