Learn Microsoft Excel Online FreeThis post will guide you how to make a cumulative sum chart in Excel. How do I create a cumulative sum chart in Excel 2013/2016. How to add a cumulative total to a line chart in Excel. Create a Cumulative Chart Assuming that you have a list of data in range B1:C5 that contain sales… read more »
This post will guide you how to sum the absolute values in a range of cells in Excel. How do I sum the absolute values with a formula in Excel 2013/2016. Sum the Absolute Values Assuming that you have a list of data in range B1:B6 that contain negative numbers and positive numbers, and you… read more »
This post will guide you how to count dates in a give year or month or day with a formula in Excel. How do I count cells based on year, month or day in Excel. How to countif by a specified date (Year or month) in a range of cells in Excel. Count Dates in… read more »
This post will guide you how to sum every nth row or column with a formula in Excel. How do I sum every nth value in a same row or column in Excel. How to sum every nth cell in a column or in a row with an Excel Formula. How to sum every second,… read more »
This post will guide you how to sum multiple columns based on the same criteria in Excel. How do I sum multiple columns based on single criteria in Excel. How to sum multiple columns using one single condition with a formula in Excel. Sum Multiple Columns based on One Criteria Assuming that you have a… read more »
This post will guide you how to countif multiple criteria on the same column in excel. How do I countif multiple criteria on the different columns in excel. How to use COUNTIF to count cells that match multiple criteria on the same column or the different columns in Excel. COUNTIF with Multiple Criteria in the… read more »
This post will guide you how to show only positive values in an excel formula. How to show formula result only if it is a positive value in excel. Is there a way to have a formula return only positive numbers in excel. Show Only Positive Values Assuming that you have a list of data,… read more »
This post will guide you how to sum a specific Row or Column in a named range in excel. Normally, you can easily sum a certain row or column in a worksheet in excel. But if you just want to sum a particular column or row in a named range, how to achieve it in… read more »
This post will guide you how to limit formula result to a maximum or minimum value in excel. For example, if you want to limit the results of a formula to a maximum value of 200, how to this this in excel. How do I return a formula result only within a specified minimum or… read more »
This post will guide you how to sort cells or text values in a column based on a specific word even if the word is in the text string in the cell. How do I sort cells in a column by the number of a specific word or words in excel. Sort Cells by Specific… read more »
