Home Blog
How to Use Regexextract Function in Google Sheets
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...
Wildcard Characters - Google Sheets
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...
All Google Sheets 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...
sumproduct criteria tips
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...
Direct Host Issue for Web Masters
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...
learn proper use of dsum criteria
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...
learn sumifs function criteria
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...
"The night is darkening round me, The wild winds coldly blow; But a tyrant spell has bound me, And I cannot, cannot go." - Emily Bronte
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...
USAGE OF DATE IN QUERY SYNTAX
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 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...

Trending!

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...

Social

723FansLike
109FollowersFollow
318FollowersFollow
51SubscribersSubscribe