xCellColor

2.2.0

FullScope Solutions

Count and sum by cell background color and by font color; count unique and duplicate values.

xCELLcolor is an Automation Add-In that affords users the ability to count and sum values by cell background color and by font color on data that has been traditionally or conditionally formatted (e.g. sum all cells in a range with a red cell background color or with a blue font color). Features are provided as user functions from with Excel (e.g. =_SumByBackgroundColor(A1:A9). Functions have been added to support counting unique values or counting duplicate values in a range. What's new in this version: Version 2.2.0: corrected installation issues on Windows 8/8.1 and some Windows 7 systems.

Operating systems:
Windows 7, Windows 8, Windows Vista, Windows XP

Additional requirements:
Microsoft Excel 2007/2010/2013, Microsoft .NET Framework v4.0

Date:
28.02.2014

Related Software

Excel Calendar Template

Create and print a monthly calendar by choosing a year and month, and schedule your activities. Read editor's review...

Free

Microsoft Office Excel 2010

Create spreadsheets, analyze and share information.

Free to try

Business Card Designer Plus

Anyone can create standard 10-up business cards in no time using the design wizard in Business Card Designer Plus, though the trial version's restrictions might

Free to try   $29.95

Microsoft Excel 2003

Create, manage, and share spreadsheets.

Update

Batch XLSX to XLS Converter

Convert Excel XLS files to XLSX and XLSX files to XLS. Read editor's review...

Free to try   $149.00