Google Sheets - SUM or COUNT if a Cell Has Notes
Learn how to create formulas that SUM or COUNT based on if the cells have notes. This is a custom function that you can get if you copy the linked Google Sheet in the blog post below, or you can copy and paste the code to create your own custom function written in Apps Script.
See the same subject on the Prolific Oaktree website with a linked Sheet:
https://www.prolificoaktree.com/sum-o...
Learn more from Prolific Oaktree:
🌳 Next Video - create an interactive task list in Google Sheets • Google Sheets - Create an Interactive...
🌳 Related Playlist - Google Apps | Full Tutorials - https://bit.ly/full-tutorials
#appscript #googlesheets #spreadsheets