Find the SUM if with 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 l...

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

Excel Calculator For Bundle Pricing using SUMPRODUCT

Let's say you have a list of products with their price in an Excel table. Now you need to create bundles that may contain different products from avai...

How to Sum Multiple Columns with Condition

We know how to sum values from one column on multiple condition. We use SUMIFS function for that. But how do we sum multiple columns on one condition....

Sum if cell is equal to value

In this article, we will learn about how to get the SUM value if cell value is equal to a specific value in Excel. In simple words, when working wi...

2 Ways to Sum by Month in Excel

Manytimes, we want to calculate some values by month. Like, how much sales was done in a perticular month. Well this can be done easily using pivot ta...

Sum if cell contains text in other cell in Excel

In this article, we will learn about how to get the SUM value if cell value is equal to a specific value in other cell in Excel. In simple words, w...

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube