The custom functions of this add-on will allow you to count and sum based on color, style and perform 3D calculations.
By:JPV
Works with:
304K+
Overview
This add-on contains 15 custom functions that extend the existing SUM, COUNT and AVERAGE functions to allow the user to perform the aggregations according to the format of the cells - background colour, font colour, and font style. There are also functions in the package that allow you to perform the aggregations across multiple sheets (within the same spreadsheet) without the need for complex formulas.
Additional information
PricingNot available
Developer
JPVTrader status unspecified
SupportNot available
Privacy policy
Terms of service
ReportFlag as inappropriate
Custom Count and Sum will ask for the permissions shown below. Learn more
Custom Count and Sum will need access to your Google account
This will allow Custom Count and Sum to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Perry Carmichael
May 29, 2026
Worked perfectly for years and years then it stopped. Looking into what's going on, Google depreciated "Rhino" runtime and installed "V8" runtime for security reasons. (I didn't ask for this...) The app creator seems to be MIA. I guess we are SOL. :-(
Is this review helpful?
Yes
No
Profile Picture
Paul Crisp
June 8, 2026
Like others, I have used this for years and it's been awesome. Looking for a replacement now that Rhino support is gone, apparently.
Is this review helpful?
Yes
No
Profile Picture
Scott Sammons
May 27, 2026
Love this add-on, but it stopped working. Now I am getting "#ERROR". How can I fix this?
Is this review helpful?
Yes
No
Profile Picture
Courtney
May 28, 2026
Very useful add-on, but it has stopped working and now giving me "#ERROR".
Is this review helpful?
Yes
No
Profile Picture
BjornGmr
May 29, 2026
It stopped working since a few days, the error: "Execution failed. The Rhino runtime is deprecated and no longer supported."
Is this review helpful?
Yes
No
Profile Picture
Steve Malarsky
June 10, 2026
Worked great until Sheets forced the update from Rhino to V8. Now it only produces errors. Looks like I'll need to find an alternative.
Is this review helpful?
Yes
No
Profile Picture
Danny Skinner
June 3, 2026
just stopped working for me as of yesterday. same issue as the other users.
Is this review helpful?
Yes
No
Profile Picture
Ogulcan Cakici
February 15, 2023
Turning things into strings with quotation marks throws me off a little bit but otherwise very cool, thank you.
Is this review helpful?
Yes
No
Profile Picture
Richard Powers
March 17, 2022
Seriously? Ranges and cell references have to be put in quotation marks? This means that to copy the formula across a range of rows/columns, I have to edit each single cell to update the row/column reference manually instead of having it relative reference automatically. This is a deal breaker.
Is this review helpful?
Yes
No
Profile Picture
A User of Custom Count and Sum
May 21, 2020
I specifically needed to count cells based on background color. This app does that just fine. The problem is, if you change colors or add new cells of the same color, it does not automatically recalculate. This renders the whole process useless since it would be distributed out to others to use. If everyone has to modify the formula to recalculate, it is a waste of time. The formula worked very well but you should really find an automated workaround instead of only suggesting the repass in the help file.
Is this review helpful?
Yes
No
1-10 of 41
Search
Clear search
Close search
Google apps
Main menu