Excel SUM

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 »

Sidebar