SUM IF using lookup values in excel

In this article, we will learn to SUM IF using lookup values in Excel. In simple words, while working with different data tables, sometimes we ne...

How to SUM If Ends With

In this article, we will learn how to sum if values only if text ends with a certain characters. Sometimes we need to find the sum of values with m...

Sum by OFFSET groups in Rows and Columns

In this article, we will learn how to Calculate Sum by groups in Rows and Columns in Excel. For Instance, you have a large list of data and you nee...

SUM time over 9 hours in Excel

In this article, we will learn how to SUM time over 9 hours in Excel. In simple words, while working with time data tables, sometimes we need to ...

Find the SUM time values having multiple criteria

In this article, we will learn about how to Sum if values having multiple criteria using SUMIFS in Excel. In simple words, while working with long...

How to Sum With 2 or More Criteria

In this article, we will learn about how to Sum if values having multiple criteria using SUMIFS in Excel. In simple words, while working with a lon...

How to Sum Last 30 Days Sales in Excel

In most of the industries, the sales and other values are summarised on monthly basis. Some times it is also summarized on standard 30 day interval....

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.