App Icon
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:
166,193
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
DeveloperJPV
SupportNot available
Privacy policy
Terms of service
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:
Profile Picture
A User of Custom Count and Sum
July 18, 2016
JP, I was honored to be a tester for this and am glad to see it as an Add-on finally. I think it does a great job and I'm sure once the word is passed around you will get a lot of downloads. I look forward to future add-ons created by you and will be happy to be a tester for those as well. TC James/mreighties :)
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
Felix Armilla
January 9, 2017
great add on.. i hope they can work-on on fast recalculation without changing anything on the formula (" ")
Is this review helpful?
Yes
No
Profile Picture
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 ?
Is this review helpful?
Yes
No
Profile Picture
A User of Custom Count and Sum
January 29, 2017
This is great Add-on The Author has through in sites
Is this review helpful?
Yes
No
Profile Picture
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!
Is this review helpful?
Yes
No
Profile Picture
A User of Custom Count and Sum
March 13, 2018
doesn't work for me
Is this review helpful?
Yes
No
Profile Picture
A User of Custom Count and Sum
January 27, 2017
No easy way to get the sum to update if based on color???
Is this review helpful?
Yes
No
Profile Picture
A User of Custom Count and Sum
July 6, 2016
Fantastic Add-On! It fit my company's need for exactly what we were looking for. JP helped with some modifications to make it scalable for our needs, so great support.
Is this review helpful?
Yes
No
Profile Picture
John Greenwood
September 20, 2016
V useful add on and got some great support, highly recommended
Is this review helpful?
Yes
No
1-10 of 38
Search
Clear search
Close search
Google apps
Main menu