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

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

Validate Input With Check Marks in Excel

In this article, we will learn about how to use the IF function to put check marks in for valid inputs in Excel. The check mark option is enabled i...

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

Evaluation of Excel Formula Step By Step

Excel provides functionality that helps us evaluate the formula. We can see how a formula is working by stepping through the formula.  In this articl...

SUMIFS using AND-OR logic in Excel

In this article, we will learn how to use AND - OR logic in SUMIFS function in Excel. AND logic is used when all conditions stated need to be sati...

Avoiding Error Displays when Formulas Return Result Calculations

It is common to produce errors in excel while working. Sometimes errors are even intentional. But how can we trap expected errors in excel? The...

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.