Brought to you by:

Hi Reader,

Welcome to the Google Sheets Tips newsletter #385, your Monday morning espresso, in spreadsheet form!

It's that time of year when you need hat and gloves one day and shorts and sunscreen the next. Last week, we had back-to-back days of 90°F. I'm sure it happens every Spring, but I always find it surprising how quickly the seasons change. Thankfully, we've also enjoyed plenty of days in the 60s and 70s (the preferred operating temperature of this Englishman).

I love Spring though, when the natural world bursts into life again after a long winter. Spring announces its arrival with vivid greens and carpets of wildflowers, to replace the drab palette of greys and browns of the colder months.

Wherever you are, I hope you can find time to get away from your screens and appreciate the beauty of mother nature.

➜ News

I.
​Google's big cloud conference, Google Next, is happening this week. So definitely be on the lookout for lots of announcements from Google in the coming weeks about new Cloud and Workspace tools. No doubt, Gemini will be the star of the show.

​Learn more here >>​

I'm not attending this year but will keenly follow the announcements, and I'll share a roundup relevant to us Sheets and Workspace users in due course.

Brought to you by: Genius Workspace Manager Automate Your Google Workspace: Bulk Operations Directly from Google Sheets Managing Google Workspace environments is complex for large organizations. Genius Workspace Manager offers a centralized, intelligent solution for bulk operations directly from Google Sheets. Through an intuitive interface, administrators can: Export unlimited data for FREE. Bulk manage users, groups, aliases, and organizational units. Assign/revoke licenses and manage OAuth tokens or domains. Oversee mobile and Chrome OS devices. Automate workflows via filters and scheduling. Operations execute securely within your environment, ensuring no external data storage. Stop wasting hours on manual tasks. Deploy Genius Workspace Manager today to automate your enterprise administration with total security and zero complexity. Get Started for Free

➜ Sheets Tip #385, in which we pay tribute to the hard-working, journeyman formula SUMIF

Whilst more showy functions like QUERY or fancy LAMBDA functions grab all the headlines, there are humble, hardworking formulas like SUMIF that remain the bedrock of our data analysis work.

The SUMIF filters and sums values in your data. As the name implies, it's really an IF test followed by a SUM.

Think of it like this: it takes a series transactions and only hits the "plus" button on his calculator for transactions that pass the criteria.

SUMIF Example

Imagine you’re tracking expenses for your local sports club. You have a list of expenses in Column A (Categories) and the costs in Column B.

To find out exactly how much you've spent on "Equipment," you’d use:

The formula tests column A for the value “Equipment”, and, if it matches, adds the value from column B to the total.

And that's it!

No more manual filtering or sorting to figure out the Equipment total.

Anatomy of the Formula

Range: Where are we looking? (e.g., your list of categories).

Criterion: What are we looking for? (e.g., "Groceries" or ">100").

Sum_Range: What are we actually adding up? (If different from the first range).

If the third argument is omitted then the first range will also be used for the sum.

This could be used to sum all values above $100, like this, for example:

Pro Tip

If you want to sum everything that isn't a certain category, use the "not equal to" operator: <>.

For example:

will give you the total of everything except those pesky administrative costs.

Thank you, SUMIF 🫡, keep doing the heavy lifting for us all!

If you enjoyed this newsletter, please forward it to a friend who might enjoy it.

Have a great week!

Cheers,
Ben

P.S. We're all doing important work now​