Excel Formulas

SUMIF with Multiple Criteria (5 Easiest Examples)

For conditional sum in Excel, SUMIF is one of the most used functions provided by MS Excel. It is a combination of SUM and IF (SUM+IF), which means ...

COUNTIF Between Two Dates

For different purposes, you may need to find how many occurrences are there between two dates. You can fetch the count value easily once you have ...

SUMPRODUCT Function with Multiple Columns in Excel (4 Simple Ways)

SUMPRODUCT function is one of the most powerful array functions in Microsoft Excel that can pull out data from an array based on the criteria along ...

Sum Every nth Column (Formula and VBA Code)

In real life scenario, you may deal with different sum operations in Excel like sum with multiple criteria, sum entire column, sum every other ...

How to Add Dates in Excel Automatically (2 Simple Steps)

Today I will be showing how to add dates automatically in Microsoft Excel. Download Practice Workbook How to Add Dates in Excel ...

Excel Add Months to Date (4 Easiest Examples)

For project planning or time management, we need to make a routine or schedule. Making time schedules, MS Excel provides different ways to add months ...

Excel Formula to Find Date or Days in Next Month (6 Quick Ways)

Microsoft Excel has provided a wide range of date & time-related formulas that we can use to find dates, days or some other time-related data for ...

How to Calculate YTD (Year-to-Date) in Excel [8 simple ways]

Microsoft Excel has provided a wide range of solutions to calculate YTD(Year-to-Date) under different criteria. In this article, you’ll be able to ...

SUMIF Multiple Ranges [6 Useful Ways]

SUMIF function is widely used for calculating the sum value from different aspects depending on criteria also. In this article, we’ll discuss the ...

How to Create Automatic Rolling Months in Excel (3 Quick 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 ...

SUMIF with Multiple Criteria in Column & Row in Excel (Both OR and AND Type)

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

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

ExcelDemy
Logo