How to Use Date Criteria in Query Function in Google Sheets...

Using date as criteria is the complicated part of any criteria formation in Google Sheet functions. Most of the case you can not use...

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

Compare Sumifs, Sumproduct, Dsum with Example in Google Sheets

I got few mails asking me to compare Sumifs, Sumproduct, Dsum with example. I also think it's now necessary as many of the Google...

Difference Between SUMIFS and SUMPRODUCT in Google Sheets

There are major difference between SUMIFS and SUMPRODUCT functions in Google Sheets. They may seem to you as similar in use. But it is...

How to Use Date Difference as Criteria in SUMPRODUCT in Google...

Date difference as criteria means the dates fallen between two given dates. In this new Google Sheets tutorial I will tell you how to...

Difference Between SUMIFS and DSUM in Google Sheets

Normally I write tutorials specifically for Google Sheets but many of them are applicable to Excel also. So the same case is relevant this...

How to Include Same Field Twice in SUMIFS Function in Google...

One of the problem you may face while using functions like DSUM, SUMIFS, SUMPRODUCT or QUERY are the use of criterion. When it comes...

How to Use Date Difference As Criteria in DSUM in Google...

I've recently written a detailed tutorial about the use of DSUM in Google Sheets. Now in this tutorial I will explain you how to...

How to Use SUMPRODUCT Function in Google Sheets

You can use SUMPRODUCT function in Google sheets in similar situations where you use SUMIFS or DSUM. I will explain you how to use...

Consolidate Data from Multiple Sheets Using Formula in Google Sheets

Many people think there is no Excel Data Consolidation alternative in Google Sheets. Of course there is no such command in Google Sheets. But...

Social

727FansLike
109FollowersFollow
307FollowersFollow