Learn Microsoft Excel Online FreeThis post will guide you how to count the number of cells equal to a specific value in a given range cells using a formula in Excel 2013/2016. How do I count the cells which are exactly equal to a numeric value or a text string in Excel. Is there a easy way to count… read more »
We can do SUM for a list or a range of values easily if we select all values together and then apply SUM function in excel. But if we only want to sum part of them based on the selection in a dropdown list, how can we do? For example, suppose we have two lists,… read more »
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 »
In statistic when calculating the total values for a range of numbers, we often count duplicate values only once. Normally, if only apply SUM function to calculate total values, it will cover all values including all duplicate values. So, we need to update the formula to make it meet our requirement. This free tutorial will… read more »
We often do some summary or statistic at the end of one month or one year. In these summary tables, there are at least two columns, one column records the date, and the other column records the sales or product number or total costs etc. If we want to calculate the total values based on… read more »
In our daily work, we usually have the problem of counting the average of a period. If the given dates are continuous, we can handle this situation very well, and if the dates are discontinuous, how do we count the average for different periods? In this article, we will use some examples to show you… read more »
This post will guide you how to count the number of checked checkboxes in your worksheet in Excel. How do I Count or sum all cells with checked boxes with a formula in Excel. Count or Sum Cells with Checked Box Assuming that you have a list of data in range A1:C5, in which contain… read more »
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 »
This post will guide you how to lookup a value and then return the sum of two or more related columns in Excel 2013/2016. How do I Use VLOOKUP function and SUM function to lookup a specific value and return the sum of all matches in columns in Excel. Vlookup to Return the Sum of… read more »
This post will guide you how to multiply the values in two columns and then sum the result of all rows in Excel. How do I multiply two columns and add up the results using SUMPRODUCT function in Excel. How to Use the Excel SUMPRODUCT function with one or more criteria in Excel. Multiply Two… read more »
This post will guide you how to find and highlight duplicate rows in a range of cells in Excel. How do I find duplicate rows in a range with a formula in Excel. How to find duplicate rows in two or three columns with Conditional Formatting feature in Excel. Find Duplicate Rows Only Find and… read more »
This post will guide you count a value across multiple worksheets in excel. How do I use COUNTIF function to get the number of occurrence of a value from multiple worksheets in Excel. How to count the number of values from multiple worksheets in Excel. How to count based on a single criteria across multiple… 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 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 count unique items in Excel Pivot Table. How do I use Pivot Table to count unique distinct values in Excel. How to get a distinct count in a pivot table in Excel. Assuming that you have a list of 5 cells with 3 unique values, and you want… read more »
This post will guide you how to sum cells if cells begin with a specific text or number in another column in excel. How do I sum if cells start with specific text or number in another cells in excel. Assuming that you have a list of data A1:B4, and you want to sum all… read more »
This post will guide you how to sum the numbers from 1 to N in Excel Worksheet. How do I sum the integers from 1 to N with an excel formula. How to write an excel formula to calculate 1+2+3+…+N in excel. Normally, we can use the SUM function to sum a list of numbers… read more »
This post will guide you how to count cells between two dates with multiple criteria in excel. How do I count records between two dates and multiple criteria with formula in excel. You can easily count cells between two dates using COUNTIFS function. and if you want to count records between two dates with two… read more »
