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

SUM if value is less than

In this article, we will learn about how to SUM if value is less than a particular values using SUMIF in Excel. In simple words, while working wit...

Sum if date is greater than given date

In this article, we will learn about how to Sum values if date is greater using SUMIF in Excel. In simple words, while working with long data sh...

Sum if cell is not equal to value

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

SUM range with INDEX in Excel

In this article, we will learn about how to get the SUM of range with INDEX function in Excel. The INDEX function returns the values of the referre...

3 SUMIF with Or Formulas

We know how to sum if two criteria match using SUMIFS function. But how do we sum if either of two criteria match. In other words, how do we sum if th...

Sum by Groups in The Excel Table

Its easy to sum by group outside the table using SUMIF function, but what if we want to sum the groups in the table. Same as pivot table. This also ea...

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