Home Blog Page 2
formula sumifs vs dsum vs sumproduct
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 Sheets users get confused with these similar types of Google Sheet functions. In this site I have already written few tutorials on how to use SUMIFS, SUMPRODUCT as well as DSUM in Google Sheets that with...
SUMIFS or SUMPRODUCT
There are major difference between SUMIFS and SUMPRODUCT functions in Google Sheets. They may seem to you as similar in use. But it is not the case. SUMIFS or SUMPRODUCT, which one is better? To get the answer to this question read the pros and cons of SUMIFS and SUMPRODUCT below. Difference Between SUMIFS and SUMPRODUCT Below are the major differences...
multiple criterion in Sumproduct and date difference
Date difference as criteria means the dates fallen between two given dates. In this new Google Sheets tutorial I will tell you how to use date difference as criteria in SUMPRODUCT function. What about other similar functions like SUMIFS and DSUM, are they same? Using date criteria in DSUM is almost match with the usage of date criteria in SUMIFS....
Highly Inspiring Quotes from Famous Painters
Below you can find selected 15 highly inspiring quotes from famous painters like Vincent van Gogh, Leonardo da Vinci, Raja Ravi Varma, Claude Monet, Pablo Picasso etc. Don't be mistaken that the quotes are only for those who are interested in painting. The below highly inspiring quotes are for all sorts of people. If you are my regular reader you may by now realised that...
DSUM VS SUMIFS
Normally I write tutorials specifically for Google Sheets but many of them are applicable to Excel also. So the same case is relevant this time too. Now back to our tutorial. I will explain the difference between SUMIFS and DSUM in Google Sheets and then elaborate it with the help of a simple easy to follow example. You may wonder...
Google Sheets SUMIFS in office
One of the problem you may face while using functions like DSUM, SUMIFS, SUMPRODUCT or QUERY are the use of criterion. When it comes to include same field twice in SUMIFS the things may not work as you wish. Whether it's SUMIFS or DSUM you can get the same result by using the criterion in a proper way. Even SUMPRODUCT...
DSUM date as criteria
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 use date difference as Criteria in DSUM. Date has to be used in a particular format in order to work it as criterion in DSUM or in any other functions. This post is exclusively for the...
SUMPRODUCT TUTORIAL
You can use SUMPRODUCT function in Google sheets in similar situations where you use SUMIFS or DSUM. I will explain you how to use SUMPRODUCT function in Google Sheets in simple as well as in complex calculations. In the starting I was using this Google Sheet function for only doing basic calculations. My favourite function, when it comes to complex...
girl using pc - google sheet data consolidation
Many people think there is no Excel Data Consolidation alternative in Google Sheets. Of course there is no such command in Google Sheets. But don't write off Google Sheets! There is a powerful function in Google Sheets to do the data consolidation in a much better way! Do you know which formula is that? I'm talking about the Query...
query function as an alternative to filter use in office
I have recently used the awesome Query feature to auto populate information based on a drop down selection. If you check that you can see how simply we can extract necessary information from a lengthy database using QUERY. It's pretty easy to use Query function as an alternative to Filter function in Google Sheets. You can use Google Sheets Query...

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