JPV
•  94,130
Overview
The custom functions of this add-on will allow you to count and sum based on color, style and perform 3D calculations.
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
Language:
Sort by:
A User of Custom Count and Sum
January 12, 2020
None of the functions currently work.
Is this review helpful?
Yes
No
A User of Custom Count and Sum
January 8, 2020
literally copy paste code adn change it exactly as the example shows, nothing
Is this review helpful?
Yes
No
A User of Custom Count and Sum
December 30, 2019
Seems like the answer to summing up the same cell across multiple sheets, until i got to auto-calculate; if the only way is recalc is to edit the formula, that's not going to fly....unless I'm missing something...back to Excel..
Is this review helpful?
Yes
No
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.
Is this review helpful?
Yes
No
A User of Custom Count and Sum
March 13, 2018
doesn't work for me
Is this review helpful?
Yes
No
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
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
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
Igor Shubovych
March 30, 2017
Does not recalculate formulas, because formulas are in strings
Is this review helpful?
Yes
No
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
1-10 of 18
Additional information
Search
Clear search
Close search
Google apps
Main menu