Sum data based on cell colour

Microsoft Office 2010 professional
May 10, 2012 at 08:52:49
Specs: Windows 7
formula depending on cell coulour

I have a row of cells which have different backgroud colours , all containing numbers

I want a total for each colour in the row



See More: Sum data based on cell colour

Report •

May 10, 2012 at 09:42:51
Excel does not have a built in function to Sum by colors.

There are a number of VBA User Defined Functions available via a Google search that might work for you.

Keep in mind that cells can be colored via the basic Fill Color feature or by Conditional Formatting. It's fairly easy for VBA to find/count/sum cells that have been colored by the Fill method, but a bit more difficult to do the same for Conditionally Formatted cells.

When you do your search, make sure you are matching the solution to your needs.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question