Excel SUM

How to Sum Values Based on Criteria List in Another Column in Excel?

Suppose we have two lists in excel, one list records the product serial numbers, these serial numbers can be duplicate, and the other list records the sales volume for products accordingly, for more details you can see the screenshot in precondition below. To calculate the total sales volume, normally we can use SUM function in… read more »

How to Count Duplicate Values Only Once in A Range in Excel?

When counting the number of times for objects appear in a list or a range, we usually record the duplicate value only once and ignore the redundant ones. We cannot apply formula with only one function to implement this in excel, so we need to update formula and use a formula combine more than one… read more »

How to Count Only Unique Values Excluding Duplicates in Excel

We enter a list of numbers or products and there are some duplicates in the list, if we want to just do count for the unique values and exclude the duplicates, how can we do? Now you can follow the below steps to solve this question by formula quickly. Prepare a list of products and… read more »

How to Extract Number from Text String in Excel

This post will guide you how to extract number from a given test string in Excel. How do I extract all numbers from string using a formula in Excel. How to get all number from a given test string using user defined function in Excel. Extract Number from String with Formula Extract Number from String… read more »

How to Count Unique Values in Excel

This post will guide you how to count unique values or distinct values with a formula in Excel. How do I Count unique values or numbers in a given range in Excel. Count Unique Values Using Advanced Filter Count Unique Values Using Formula Assuming that you have a list of data that you want to… read more »

How to Sum Range Ignoring Errors in Excel

This post will guide you how to sum range of cells ignoring Errors in Excel. How do I sum and ignore errors with a formula in Excel. How to sum range ignoring all error values with VBA macro in Excel. Sum Range Ignoring Errors with Formula Sum Range Ignoring Errors with VBA Sum Range Ignoring… read more »

How to Use SUMIF with Multiple Criteria in Same Column in Excel

This post will guide you how to SUMIF with multiple criteria in same column in Excel. How do I use SUMIF with multiple criteria in one column in Excel. SUM Cells with Multiple Criteria in Same Column Assuming that you have a list of data in range A1:B6, in which contain sales data. And you… read more »

How to Sum Same Cell in Multiple Worksheets in Microsoft Excel

This post will guide you how to sum same cell in multiple worksheets with a formula in Excel. How do I sum same cell across multiple worksheets in Excel 2013/2016. Sum Same Cell in Multiple Worksheets Assuming that you have three worksheets (1-Q, 2-Q, 3-Q) in your workbook, and you need to calculate the total… read more »

How to Average a Range and Ignore Zero in Excel

This post will guide you how to average a range of cells and ignoring all zero values in Excel. How do I Average numbers in a given range and ignore zero values with a formula in Excel. How to ignore zero when averaging a range of data in Excel. Average a Range and Ignore zero… read more »

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 »

Sidebar