Count or sum cells by background or text color in Google Sheets with two free custom formulas, COUNTBYCOLOR and SUMBYCOLOR. No add-on.
COUNTBYCOLOR
SUMBYCOLOR
The script and full instructions are on GitHub: DecodedXR/count-by-color. It’s MIT licensed and free.