Background color
Capture the color from the active cell or choose a color, then calculate against the selected range.
Sum & Count by Color — Resonlix
Calculate by cell color.
Calculate by cell color.
Preview before you insert.
Select a range, choose a background or font color, then calculate any of 13 functions: SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, AVERAGEA, MIN, MAX, PRODUCT, MODE, STDEV, VAR and MEDIAN. The source range stays read-only and the result is inserted only into the destination cell you choose.
New installations receive seven days of full Pro access. No card required for the trial.
Select a source rangeRead only
Choose background or font colorFont on Pro
Preview SUM / COUNT / moreBefore insert
Insert one verified resultExplicit destination
Changing a cell color requires Refresh. Function by Color reads the live range again and never rewrites the source cells.
One focused workflow
Color-based calculations without fragile custom formulas.
Font color on Pro
Use the same calculation workflow against rendered font colors without changing source formatting.
13 calculations
Pro unlocks SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, AVERAGEA, MIN, MAX, PRODUCT, MODE, STDEV, VAR and MEDIAN. Free keeps SUM and COUNT.
Preview first
See the result and matching-cell counts before any destination cell is written.
Stale-preview protection
If values or colors change after Preview, Insert stops and asks you to refresh first.
Saved setups
Save range and calculation metadata without storing the contents or formulas from your cells.
Start with the two common calculations. Upgrade for the full toolkit.
| Capability | Free | Pro |
|---|---|---|
| SUM by background color | Yes | Yes |
| COUNT by background color | Yes | Yes |
| 11 additional calculations | — | Yes — 13 total |
| Font-color calculations | — | Yes |
| Saved calculations | 1 | 20 |
| Preview + explicit Refresh | Yes | Yes |
Seven days of Pro on a new installation.
Try all 13 calculations, font color and multiple saved setups first. After the trial, keep Free or upgrade.