Website banner for SpreadsheetClass.com

Learn to automate and grow your business with spreadsheets

  • Home
  • Google Sheets
    • Tutorial
    • Formulas
    • Tips
    • Formatting
    • Error Troubleshooting
  • Cheat Sheet
    • Free PDF Cheat Sheet
    • Ultimate Cheat Sheet spreadsheet
  • Templates
    • Microsoft Excel Templates
    • Google Sheets Templates
  • Dashboards
    • Full dashboards course
    • Basic dashboard tutorial
  • Youtube
  • About
    • About
    • Contact
    • Hire an expert
    • LinkedIn
  • Excel
    • All Excel Lessons
    • Excel Templates
    • Excel Formulas
    • Excel Tips
    • Excel Formatting
    • Excel Error Troubleshooting
  • Home
  • Google Sheets
    • Tutorial
    • Formulas
    • Tips
    • Formatting
    • Error Troubleshooting
  • Cheat Sheet
    • Free PDF Cheat Sheet
    • Ultimate Cheat Sheet spreadsheet
  • Templates
    • Microsoft Excel Templates
    • Google Sheets Templates
  • Dashboards
    • Full dashboards course
    • Basic dashboard tutorial
  • Youtube
  • About
    • About
    • Contact
    • Hire an expert
    • LinkedIn
  • Excel
    • All Excel Lessons
    • Excel Templates
    • Excel Formulas
    • Excel Tips
    • Excel Formatting
    • Excel Error Troubleshooting
  • Home
  • Google Sheets
    • Tutorial
    • Formulas
    • Tips
    • Formatting
    • Error Troubleshooting
  • Cheat Sheet
    • Free PDF Cheat Sheet
    • Ultimate Cheat Sheet spreadsheet
  • Templates
    • Microsoft Excel Templates
    • Google Sheets Templates
  • Dashboards
    • Full dashboards course
    • Basic dashboard tutorial
  • Youtube
  • About
    • About
    • Contact
    • Hire an expert
    • LinkedIn
  • Excel
    • All Excel Lessons
    • Excel Templates
    • Excel Formulas
    • Excel Tips
    • Excel Formatting
    • Excel Error Troubleshooting

How to filter based on a list in Google Sheets with FILTER COUNTIF

Written by Corey Bustos Updated on April 16, 2019 in

An example of how to filter based on a list in Google Sheets by using the FILTER and COUNTIF functions- A list of employees and their contact information being filtered by a list

Related Posts:

  • How to filter based on a list in Excel
  • How to filter based on a list in Google Sheets
  • Using the "Not Equal" sign in any formula in Google Sheets
  • Using the FILTER and UNIQUE functions together in…
  • Filter where cells contain / do not contain criteria…
  • Using the FILTER and TRANSPOSE functions together in…
Tweet Share Pin It Print

Welcome to Spreadsheet Class!

Corey Bustos

My name is Corey, I have been building spreadsheets for companies for over 7 years, I was a data specialist at an online school for 5 years, and I created this website to help people learn how to use spreadsheets.

Read More
  • Contact
  • About
  • Hire an expert
  • Video course
  • Formula cheat sheet
  • YouTube lessons
Example image of Google Sheets cheat sheet for sidebar
Free Dashboards image for the footer

Dashboard video tutorial

  • Hire an expert
Connect with me on LinkedIn
Free Cheat Sheet image for the footer
Copyright © 2023 Silver Sky, LLC. Silver Sky, LLC is a limited liability company headquartered in Colorado, USA. — Designed by WPZOOM
Contact
 
Privacy Policy
 
Terms and Conditions