Sometime, you might find the need to replace blanks in a Google Sheet with Zeroes. I had that need and found this helpful site. As Registrar for our volunteer-led Girl Scout Day Camp, I am responsible for collecting camp fees. I do this through PayPal. We send out Confirmation Emails with all sorts of information including…
Category: Spreadsheets
Unique and ArrayFormula Make Counting and Occurrence in a Column a Breeze!
How many are on each bus? In a Google Form, I am collecting bus information with three options to choose from. I needed a way to count the number of occurrences of each, so I know how many are on each bus. Following the instructions found here: https://www.extendoffice.com/documents/excel/4707-google-sheets-count-number-of-occurrence.html, I was able to easily accomplish it! I did…