Excel SUM

Count the Number of Weekends between Two Date

This post will guide you how to count the number of weekends between two dates in Excel. How do I get the number of weekends between 2 dates with a formula in Excel. How to count weekend days between dates in Excel. Count the Number of Weekends between Two dates If you want to calculate… read more »

Make a Cumulative Chart

This 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 »

Sum the Absolute Values in Excel

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 »

Count Dates in Given Year/Month/Day in Excel

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 »

Sum Every Nth Row or Column

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 »

Sum Multiple Columns based on One Criteria

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 »

COUNTIF with Multiple Criteria

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 »

Show Only Positive Values

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 »

Sum Specific Row or Column in Named Range

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 »

Limit Formula Result to Maximum or Minimum Value

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 »

Sidebar