Latest Posts

How to Create Automatic Rolling Months in Excel (3 Easy Ways)

Today I will show how you can create a series of automatic rolling months in Excel and then arrange your data according to the series created. ...

SUMPRODUCT Multiple Criteria Lookup

Once you are familiar with Excel, one thing may come to your mind often, how you can use the SUMPRODUCT function with multiple criteria. In this ...

SUMIFS with Multiple Criteria in the Same Column (5 Ways)

Sometimes we need to add values based on one or many criteria. Excel makes this easy by providing functions such as SUMIFS. Where SUMIF is for adding ...

SUMPRODUCT with INDEX and MATCH Functions in Excel

In MS Excel, there is a huge diversity of using SUMPRODUCT with INDEX and MATCH functions together. In this article, I’ll try to illustrate how we ...

Sum Matching Multiple Criteria in Column & Row Using SUMIFS in Excel

Today I will be showing how you can calculate the sum in any row or column matching multiple criteria using the SUMIFS() function in Excel. Download ...

Sum Values Based on Date in Excel

While working with data sets that contain dates, you may have to sum the values based on the given date frequently. In this article, we’ll focus ...

Excel Year to Date Sum Based on Month (3 Easy Ways)

Year-to-Date in short YTD is used to start the first day of the current calendar year up to the current date. It is mostly used in analyzing a ...

Sum Multiple Columns Based on Multiple Criteria

You may need to calculate the sum of multiple columns. Once you know the methods it will seem as easy as you like. The agenda for today is showing ...

Sum Based on Column and Row Criteria in Excel (7 Handy Ways)

There is a wide range of suitable methods to sum up a range of cells based on column and row criteria in MS Excel. In this article, I’ll try to ...

How to Sum by Month Using SUMIF in Excel

Today I will be showing how you can sum data by month using SUMIF() and SUMIFS() functions in Microsoft Excel. Download Practice Workbook How to ...

SUMIF Multiple Criteria Different Columns

Different circumstances may demand the calculation of the sum of cells using multiple criteria. Today, we will show you calculate the sum using the ...

COUNTIF Multiple Ranges Same Criteria in Excel

Sometimes we may need to work with multiple ranges on the same criteria in terms of searching, counting, or sorting. In this way, MS Excel helps us ...

COUNTIF Greater Than and Less Than [with Free Template]

Using the COUNTIF function, we can easily count the number of cells based on a given condition. In this article, I’ll discuss how you’ll count ...

COUNTIFS to Count Across Multiple Columns in Excel

COUNTIFS function provides plenty of opportunities to count cells under different criteria across multiple columns or rows. In this article, I’ll try ...

Index Match Multiple Criteria in Rows and Columns in Excel

Today I will be showing how to sort out cells matching multiple criteria in rows and columns in Microsoft Excel using the INDEX and the MATCH ...

ExcelDemy
Logo