App Icon
JPV
•  154,915
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:
Profile Picture
Justin Lanciault
February 13, 2021
Easy to use, but does not update so kind of pointless in all honestly. Had high hopes, but they were crushed
Is this review helpful?
Yes
No
Profile Picture
ALEX LIM
December 23, 2020
Not working at the time of this post. Even Example sheets are not working.
Is this review helpful?
Yes
No
Profile Picture
Melanie Hoyle
December 22, 2020
Hopeless. I tried a simple calculation for adding value in cells then minus the value in cells that contained a strikethrough. I was mistakened in realising it was calculating the value in the cells and minusing the number of cells that had a strikethrough rather than the value in them...*sigh*
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 9, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
Profile Picture
Louise Penrose
December 9, 2020
as per previous reviewer, it is showing as #NAME? error
Is this review helpful?
Yes
No
Profile Picture
Ras Fernando
October 27, 2020
Doesnt work for me, even the test sheet shows #NAME? Errors
Is this review helpful?
Yes
No
Profile Picture
JB Northwest
August 18, 2020
Does not update counts so basically a useless gimmick that works one time.
Is this review helpful?
Yes
No
Profile Pciture
James
November 17, 2020
Apparently it can in some cases using the following formula =countBackgroundColor("B2:B21","B2", B2:B21) Works for me on Coloured Font but apparently not for font changes or background colour changes Ref: the help doc.
Profile Picture
Joshua Carrasco
July 24, 2020
This add-on worked well to count based on background color. As a previous user had mentioned, if any cells within the function range have their background color changed the formula won't recalculate but not sure if that's a limitation of Google Sheets or if the dev of this add-on can fix it later on. Regardless it worked for what I needed it for.
Is this review helpful?
Yes
No
Profile Picture
A User of Custom Count and Sum
July 8, 2020
Sum for coloured text worked great for me!
Is this review helpful?
Yes
No
Profile Picture
John Haynes
June 12, 2020
I had high hopes that this would solve a problem I was facing with a sheet. I read the docs, opened the example sheet, verified that the add-on showed in the add-ons menu on my sheet and still get "Unknown function" error when I attempt to use any of the functions.
Is this review helpful?
Yes
No
1-10 of 36
Additional information
Search
Clear search
Close search
Google apps
Main menu