JPV
•  90,586
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
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
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
Profile Picture
A User of Custom Count and Sum
May 12, 2020
I installed this add-on for the SUMALLSHEETS function, which I hoped would work like Excel but sadly it doesn't auto-update when one of the computed values changes. To update the sum the formula must be edited or, in the case of several SUMALLSHEETS being used on the same page, the page must be reloaded. I don't see how this is any better than using a longer formula like Sheet1!A1+Sheet2!A1+Sheet3!A1. I haven't tried any of the count-by-color, etc. functions of this add-on so I can't comment on those.
Is this review helpful?
Yes
No
Profile Picture
Melissa Ghionis
May 8, 2020
Sadly the functions didn't work for me. I needed it to add how up how many cells contain a certain font color. I followed the formula exactly and received the #NAME? error with a note that said, "Unknown Function." The same error showed up in my practice sheet. Such a shame...
Is this review helpful?
Yes
No
Profile Picture
A User of Custom Count and Sum
May 6, 2020
Didn't work for me
Is this review helpful?
Yes
No
Profile Picture
A User of Custom Count and Sum
May 6, 2020
I have tried to add the force recalculation to this but haven't had success. I added the code for the script editor as well as the HELPER tab, but still no luck. Is there something I am doing wrong?
Is this review helpful?
Yes
No
Profile Picture
A User of Custom Count and Sum
May 3, 2020
Doesn't work for me.
Is this review helpful?
Yes
No
Profile Pciture
A user of Custom Count and Sum
May 4, 2020
Was the extension installed and did you use the function? Can you elaborate a little please?
Profile Picture
A User of Custom Count and Sum
April 20, 2020
brilliant! I think a lot of people would find this more helpful if they reference the Example Sheet to see the breadth of potential (and exactly which formula you need to enter)
Is this review helpful?
Yes
No
Profile Pciture
A user of Custom Count and Sum
May 4, 2020
I am unable to see the addon even after clicking INSTAL many times. It asks for account and then starts to instal, then suddenly nothing happens and it comes out.
Profile Pciture
Stephanie Bridge
April 21, 2020
I can't get documentation to show up
Profile Picture
Marc Poulaud
April 17, 2020
Pants - doesn't work on counting rows with background colour.
Is this review helpful?
Yes
No
1-10 of 28
Additional information
Search
Clear search
Close search
Google apps
Main menu