Help & Support
Send Feedback
Custom Count and Sum
The custom functions of this add-on will allow you to count and sum based on color, style and perform 3D calculations.
JPV
6 users
Works with
Install
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.
Reviews
Chris Chappell
November 18, 2018
It does what we needed for the most part. Does not always update when cell colors change... Usually does not. Have to close / re-open sheet or modify formula for it to update.
Submit reply
Cancel
A User of Custom Count and Sum
March 13, 2018
doesn't work for me
Submit reply
Cancel
A User of Custom Count and Sum
March 9, 2018
I am using it across with two sheet. I think it will be useful if trigger recalculate when I add new record to an area.
Submit reply
Cancel
A User of Custom Count and Sum
September 18, 2017
I've been looking for something like this for years! Add the value of cells based on background color. Great for scheduling special work weeks. For auto-refresh, check the documentation! You basically just need to type the string of cells again at the end of the formula. Thanks for this JPV!
Submit reply
Cancel
A User of Custom Count and Sum
May 5, 2017
Love it, 1 question : is it possible to count part of the content of a cell ?
Submit reply
Cancel
Igor Shubovych
March 30, 2017
Does not recalculate formulas, because formulas are in strings
Submit reply
Cancel
A User of Custom Count and Sum
January 29, 2017
This is great Add-on The Author has through in sites
Submit reply
Cancel
A User of Custom Count and Sum
January 27, 2017
No easy way to get the sum to update if based on color???
Submit reply
Cancel
Felix Armilla Jr
January 9, 2017
great add on.. i hope they can work-on on fast recalculation without changing anything on the formula (" ")
Submit reply
Cancel
A User of Custom Count and Sum
December 15, 2016
Great bundle of tools! The ability to use formatting to affect my formula is exactly what I needed. Great support too, was able to address my need for a refresh option.
Submit reply
Cancel
A user of Custom Count and Sum
August 3, 2017
Hi Cory - what was the solution for the refresh option?
A user of Custom Count and Sum
December 21, 2016
What was the resolution for the refresh? I'd like it to automatically update the value upon change of the cell color but I'm finding this is harder to do than it sounds to a non-tech person. :-)
1-10 of 15
Additional information
Developer
Search
Clear search
Close search
Google apps
Main menu