Category Archives for Formulas

How to Sum Values Between Two Dates using SUMIFS

How to Sum Values Between Two Dates (SUMIF Between Dates)Yes, you heard it right, using SUMIFS is the easiest and the best method to sum values between two dates (i.e. a range of dates).Let’s say, you are working in a trading company and your boss asks you to get the total sales amount for last […]

How to use SUMIF with Wildcard Characters in Excel

SUMIF is one of my favorite Excel functions and I’m sure it’s yours also.But one thing which I always worry about it, we can only sum values when criteria fully match with values.Let’s say, your name is John Martin.In this case, if we want to sum values using your name we should have your full […]

How to Highlight Dates Between Two Dates

 You have dates in column and you want to highlight all the dates which are between the range of two dates. Huh? OK, alright! Let’s say you have a start date 17-Jan-2017 and an end date 19-Mar-2017, and from the dates column, you want to highlight all the cells in which date is between these two dates.For this, […]

How to Create a Data Validation with Date Range

 Let say you need to create a data validation for dates in which you want to use a specific date range. In simple words, you want when a user enters a date in a cell that should be within a range of dates which you specify. Well, this can be done by using a custom formula based […]

How to Average TOP 5 Values in Excel

How to Average TOP 5 Values in ExcelLet say you have a line-up of 20 products in your company and you have data for monthly sales of all the 20 products. From that data, you want to calculate the average of top 5 products. In short, you want to get the average of top 5 values […]