Our addon for Google Sheetsโข will allow you to calculate colored spreadsheet cells that have the same background (Fill color) and text color. Identify the maximum, minimum, sum, count (numbers), count (text), average, countblank, product, mode, stdev, var, and median values. Examine cell color and count the number of boxes left blank. To Start Function by Color for Google Sheetsโข : 1. Install the addon 2. Open spreadsheet 3. Click the Extensions menu 4. Click Function by Color 5. Click Start 6. You will see a sidebar on the right side How to use the function by color for Google Sheetsโข. 1. Select Range and click โSelect Rangeโ input for the range to automatically add the input. For Example C3:C12 2. Select a cell and click โSelect a cellโ input for the cell to automatically change the โText colorโ and โFill colorโ or manually select โText colorโ and Fill Color. 3. Select Function SUM, COUNT (numbers), COUNTA (text), COUNTBLANK, AVERAGE, MIN, MAX, PRODUCT, MODE, STDEV, VAR, or MEDIAN . 4. Select the cell (the result will be in this cell) and click โThe result cellโ input for the range to automatically add. For example F8 5. If needed check the โcheckboxโ. The resulting cell will be the same as the selected โText colorโ and โFill colorโ. 6. Select โCalculate Inโ input. 7. Click the โโApply Functionโ button. The result should look like something like this: =SUM(CELLSVALUEBYCOLOR(โ#4a86e8โณ,โ#0c343dโ,โC3:C12โณ)) OUR OTHER PRODUCTS - Form Field Limit | Removal | Eliminator - allows you to add limits to paragraphs, short answers, dates, multiple choices, checkbox options, dropdowns, linear scales, times, and more in your Google Formโข - Document File Generator | Files Generator- Create custom templates for your Google Sheetโข, Google Docโข, and Google Slideโข files into PDFs, Microsoft Office documents, Excel, and Powerpoint - Form Choice Limiter Limit | Choice Remove Removal developed to limit response counts for scheduled appointment options or limit response counts for multiple choice, checkboxes, and dropdown question options. If the limit is reached the Form Choice remove option in the form. It is the most accurate and easy-to-use choice eliminator available in the marketplace. - EWD Mail Merge | Document Mail | Slide Mail is built for Google Sheetsโข, Google Docsโข, Google Slidesโข, and Gmailโข in order to solve email sending campaigns so that every one of your recipients gets a personalized email. Our Mail Merge can be used with Google Sheets, Documents, and Slides. All your mail will be seen in the primary mail list avoiding spam, promotion, and social boxes. - Form Response Limit | Form Enable | Form Limiter allows you to add limits to the number of responses your Google Formโข can have. It also allows you to control when you can enable or disable your Google Formโข based on the date and time. When your form gets disabled at a certain time, you will receive an email letting you know it is disabled, and you will also get an email when the form's response limit is reached. SUPPORT Need help? Just send a message to us. Contact us: https://fbc.everestwebdeals.co/contact-us/ Website: https://fbc.everestwebdeals.co