Count Cells Without Certain Text Anywhere in the Cell
Count cells that do not match a condition
query
Count Cells That Don’t End With Certain Text – Google Sheets
Count the cells that DON’T end in a specific string of characters.
Summarize Data by Quarter in Google Sheets
Summarize your Google Sheets data by quarter using three methods: functions, pivot tables, and query.
QUERY Function – Google Sheets
The QUERY function in Google Sheets uses SQL-like syntax to analyze and return your spreadsheet data in a new table. While adding the SQL syntax provides this function with flexibility, it also makes learning harder. The family of FILTER functions in Google Sheets offers a simpler alternative to the QUERY function. But they don’t recognize … Read more