Home Blog

### How to Use Regexextract Function in Google Sheets and RE2 Regular Expressions

Google Sheets Regex functions are a challenge to learn for even for its regular advanced users. So this time I dedicate my topic to Regexextract function in Google Sheets. This function is one among the three Regex functions in Google Sheets. You cannot find enough resources or discussion connected with Google Sheets Regex functions anywhere. The reason, it's bit complicated. I...

### How to Use Wildcard Characters in Google Sheets Functions

There are three main wildcard characters in Google Sheets that you can use with certain Google Sheets functions. Then what are those so called wildcard characters? They are ~ (tilde), * (asterisk) and ? (question mark). These single wildcard characters can represent or replace with single or multiple other characters in functions. Then how to use wildcard characters in...

### How to Use All Google Sheets Count Functions [All 8 Count Functions]

Do you know how many count functions are there in Google Sheets? May be not, right? There are eight count functions in Google Sheets. The following are the all eight count functions in Google Sheets. 1. COUNT, 2. COUNTA, 3. COUNTUNIQUE, 4. COUNTBLANK, 5. COUNTIF, 6. COUNTIFS, 7. DCOUNT and 8. DCOUTA. Now let us learn how to use all Google...

### Chart to Learn Text, Date, Numeric Criteria in Sumproduct Function in Google Sheets

This is an ultimate tutorial on criteria use in Sumproduct function in Google Sheets. When you want to learn any function in Google Sheets, the stumbling block between you and the function will be the criteria part. I am sure about this. So this time let us learn how to use text, date, numeric criteria in Sumproduct function with...

### Host Directive Not Given in Robots Text File Issue [Solved]

Have you ever come across the message Host Directive Not Given in Robots Text file? Possibly, if you are a webmaster and submitted your website or blog to Yandex webmaster tools. Also the different version of the same, we can't say error, is applicable to Google Search Console too! Though there is a section on Info Inspired for webmasters tagged Tips for...

### How to Properly Use Criteria in DSUM in Google Sheets [Chart]

In this tutorial I am not going to explain how to use DSUM function. It's already explained! You can find some rare and useful DSUM tutorials by using the search option on this site. Here my topic is different. Here I am going to tell you how to properly use criteria in DSUM, whether it should be within quotes, without...

### How to Use Different Criterion in SUMIFS Google Sheets Function

Knowing the use of criterion is important in learning most of the functions in Google Sheets. SUMIFS function is no different. Before going to learn how to use different criterion in SUMIFS function, I know I should explain you the term criterion. What is Criterion in Functions? The origin of the word criterion is date back to 17th century. It's a...

### 10 Best Emily Bronte Quotes on Love and Passion

The below Emily Bronte Quotes on love and passion carry the emotion in its wildest form. They are some of the best quotes in this line which I have come across recently. It generate some different mood deep inside our heart. Emily has written only one Novel in her short span of life time. That's an evergreen classic novel! Emily...

### How to Use Date Criteria in Query Function in Google Sheets [Date in Where Clause]

Using date as criteria is the complicated part of any criteria formation in Google Sheet functions. Most of the case you can not use the date as it's. It should be converted to text using different approaches and the use may wary function to function. I will explain you how to use date criteria in Query function in Google Sheets...

### Learn Query Function with Examples in Google Sheets

You should learn QUERY function in order to manage your Google Sheet data efficiently. Query is simple to learn. Just use the Query function frequently to become an expert in using it. There may be two reasons why you didn't try this function so far. First one you are not aware of this powerful function or you may think...

### 10 Highly Inspirational Picture Quotes

We are just starting today a new section here on Info Inspired for inspirational picture quotes. We realize that quotes have the power to...