Google Sheet Formulas

Find the Google Sheet formula you’re after to solve your problem, with these examples. Click the link to read the post. Posts without active links are in the works and coming soon.

Have a specific question? Drop me a line here.


General questions

> How do I zoom in or out in Google Sheets?


Date formulas

> How do I get the first and last days of the current month?

> How do I get the first and last days of the prior month?


Lookup formulas

> How do I do a vlookup in Google Sheets with wildcards for partial matches?

> How do I do a VLOOKUP to the left in Google Sheets?

> How do I return multiple values with a single VLOOKUP formula in Google Sheets?


Formatting

> Tips to format your data tables in Google Sheets

> How can I combine text and numbers in a cell and keep the number formatting?


Text formulas

> How do I reverse text in a cell in Google Sheets?


Formulas for manipulating data

> How do I create a drop down list in Google Sheets?

> How do I use the QUERY() function in Google Sheets?

> How to filter with dates in the QUERY function

> How do I use the FILTER() function to retrieve specific data in Google Sheets?

> How can I use an OR condition inside the FILTER() function?

> How to create dynamic named ranges in Google Sheets


Array formulas

> How does the array formula work in Google Sheets?

> Use Array Formulas to auto-fill calculation columns when using Google Forms

> How to add a total row to a Query Function table in Google Sheets


Import formulas

> How do I do basic web scraping with the IMPORT formulas in Google Sheets? (examples from the New York Times, the Washington Post and Business Insider)

> How can I import Facebook Page metrics into a Google Sheet?

> How can I import Twitter Follower counts into a Google Sheet?

> How can I import Instagram Follower counts into a Google Sheet?

> How can I import Google+ Follower counts into a Google Sheet?

> How can I import YouTube channel counts into a Google Sheet?

> How can I import Pinterest channel counts into a Google Sheet?

> How can I import Alexa ranking data into a Google Sheet?

> How can I import Quora follower data into a Google Sheet?

> How can I import Reddit data into a Google Sheet?

> How can I import Spotify data into a Google Sheet?

> How can I import Soundcloud data into a Google Sheet?


Data Visualization questions

> Histogram and Normal Distribution Curves in Google Sheets

> Creating dynamic charts using Google Sheets drop down menus

> Everything you ever wanted to know about sparklines in Google Sheets

> How can I add dynamic bands to my charts in Google Sheets to show specific data?

> How do I create a waterfall chart in Google Sheets?

> How do I create a funnel chart in Google Sheets?

> How can I annotate specific data points in Google Sheets charts?

> How do I add data labels to only the last datapoint of my series in Google Sheets charts?

> Advanced line chart in Google Sheets with annotations, historic series and data labels

> How do I create a multi-colored line chart in Google Sheets?


Statistical formulas

> How do I create a histogram in Google Sheets?

> How do I overlay a normal distribution curve onto a histogram in Google Sheets?


My formula gives me an error

> An error message popup prevents me entering my formula

> I’m getting an #N/A error message. How do I fix it?

> I’m getting an #DIV/0! error message. How do I fix it?

> I’m getting an #VALUE! error message. How do I fix it?

> I’m getting an #REF! error message. How do I fix it?

> I’m getting an #NAME? error message. How do I fix it?

> I’m getting an #NUM! error message. How do I fix it?

> I’m getting an #ERROR! error message. How do I fix it?

> I’m getting an #NULL! error message. How do I fix it?

> Other strategies for dealing with errors

> Functions to help deal with formula errors in Google Sheets

> Help! My formula is STILL not working

One thought on “Google Sheet Formulas”

  1. Hi. You have superb content related with Google Sheets. I liked the one on (1) VLOOKUP using wild cards and (2) replying to Google Forms with Sheets and App script.

    I have a doubt: is it possible to (1) collect data through Google Form, from the user (who maynot have a Google account), (2) pass this data to a spreadsheet and do a VLOOKUP for data entered in form and (3) pass the remaining data returned by VLOOKUP back to the same or a new form.

    So basically I am looking for a way to retrieve data from a Sheet and send to a Form.

    Any help will be appreciated.

    Keep up the good work!

Leave a Reply

Your email address will not be published. Required fields are marked *