Save Time Writing Formulas in Google Sheets with Gemini

In Google Sheets, Gemini can help you write formulas. It can help with simple formulas, like finding the sum or average.

In this example, we have clicked the Gemini button at the top of the sheet to open the Gemini panel and asked Gemini to 'Create a formula to sum column H'

it gives us the formula =SUM(Sales[TotalSales]) and the result £2657.25

We can get the average by doing the same, asking Gemini, 'Create a formula to show the average of column H'

It can also help with Conditional Formulas, like COUNTIF, which can help count specific values in a range.

In the example below, we have asked Gemini to 'Create a formula to show the count of Liverpool in column C'

It has provided the formula and the result; you can then click 'insert' to add it to your sheet.

To get the sum of sales for a specific city, we could ask it to 'Create a formula to show the total sales for Liverpool' to ask Gemini to create a SUMIF formula.

It can even help with formulas that use complex functions like the FILTER function or XLOOKUP.

XLOOKUP is a versatile function that allows you to search for a value in one column (or row) and return a corresponding value from another column (or row) in the same dataset.

Here's an example of how we can get Gemini to do an XLOOKUP

These are just a few examples of how Gemini can save you time when creating formulas in Google Sheets. Keep exploring and trying different prompts, as they will continue to improve all the time.

To learn more about Google Sheets book, CloudShed's live and interactive Google Sheets training sessions.

Or purchase our On-Demand Google Sheets courses.