Add-ins.com home page
Questions? E-mail us or call us 302-584-1771, 8AM to 10PM U.S. East Coast Time 7 days a week
     

View Cart

US $29.95

Add to shopping cart

Quantity
Discounts

Money back
guarantee

Colored Cells Assistant
An add-in product for Microsoft Excel

  • Sum cells based on background or text color
  • Count or average cells based on color
  • Have Excel functions use only colored cells and
    ignore non-colored cells

Download a trial version now!

The Colored Cells Assistant add-in for Microsoft Excel adds the ability to write equations based on cell color.  It is compatible with Microsoft Excel 2010-2021 and Office 365.   The following screenshots illustrates the challenge and the solution:

Before     After
 

All we did was use the Colored Cells Assistant to insert a formula that sums just the green colored cells!

The Colored Cells Assistant will return just the cells with the color you indicate.  For example, if you color some cells in a range with a yellow background you can use a Colored Cells Assistant function to return or sum just those cells. It can easily average, find the minimum or maximum, or the count colored cells. And you can use it with any of Excel's functions.

The Colored Cells Assistant is menu driven and creates the formulas you need

You can even set the background color option to be "colored" so that you can sum, average, count, etc cells that are yellow, blue, green, or any color except no fill.  This allows you to color cells any way you want and still do computations on just the colored cells. You do not need to specify a color in this case!

The Colored Cells Assistant only recognizes cells colored using Excel color buttons or by selecting a color via Format, Cells.  It does not recognize the color of cells formatted by conditional formatting.

If you send a workbook to another person and they do not have the Colored Cells Assistant, they will need to purchase a license to it in order for the Colored Cells Assistant functions to work for them.

Order online from our secure service.
Get delivery in minutes!

Add to shopping cart

  US $29.95


Copyright 2024 Add-ins.com LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of Add-ins.com LLC.