Spreadsheet

extract all numbers from text and Sum it

Extract All Numbers from Text and SUM It in Google Sheets

There are two different formulas in Google Sheets that you can use to extract all numbers from text and Sum it. Even though we want to deal with numbers, without Text functions, we can't...
Convert Month Name in Text to Month Number

Formula to Convert Month Name in Text to Month Number in Google Sheets

What is the function to convert month name in text to month number in Google Sheets? Actually there is no such function to do this. But you can do it by using a Date function...
Google Sheets Query Hidden Row Handling

Google Sheets Query Hidden Row Handling with Virtual Helper Column

I am sure that our topic discussing about Google Sheets Query hidden row handling is quite new to you. Yup! Using Google Sheets Query function, you can select only visible rows in Google Sheets....
SUMIF Excluding Hidden Rows in Google Sheets

SUMIF Excluding Hidden Rows in Google Sheets [Without Helper Column]

SUMIF formula is useful for conditional SUM in Google Sheets. It's quite easy to use. But do you know how to use SUMIF excluding hidden rows in Google Sheets? Google Sheets SUBTOTAL function can help you...
Sum by Month in Google Sheets

Sum by Month in Google Sheets Using Combined SUMIF Formula

Here I'm going to share you a 'magical' SUMIF formula to sum by month in Google Sheets. I'm not exaggerating. See what I am going to do. I am a huge fan of Google Sheets...
Create Month Wise Summary in Google Sheets

Create Month Wise Summary in Google Sheets Using Query Formula

It's not a tough task to create month wise summary in Google Sheets. There are few good options like Pivot, SUMIF and QUERY. How to summarise data for month wise in Google Sheets? In Excel,...
Create GANTT Chart in Google Sheets

Create GANTT Chart in Google Sheets Using Stacked Bar Chart

Let's see how to create a basic GANTT Chart in Google Sheets with the help of Stacked Bar Chart. This is purely a basic GANTT chart and not suitable for big projects. But I...
Compare Two Sheets in Google Sheets for Mismatch

How to Compare Two Sheets in Google Sheets for Mismatch

May be you have sufficient reasons to compare two sheets in Google Sheets for mismatch. Whatever it may be, you can easily do it. In Google Sheets, there is no built-in option for comparing...

Google Sheets Formulas

Make the Formulas Simple by Applying Names to Range of Cells...

Hope you are a regular reader of our Google Doc Spreadsheet tutorials. We already have some rich content there to help you improve your...

Inspiration

15 Failure to Success Inspirational Quotes

The below failure to success inspirational quotes are for those who want to overcome the fear of failure with some sort of self motivation or...