Excel Examples

How to Count Cells that do not Contain Errors in Excel

This post will guide you how to count the number of cells that do not contain errors within a range of cells using a formula in Excel 2013/2016 or Excel office 365. How do I count the number of cells without any errors using a simple formula in Excel. Count Number of Cells that do… read more »

How to Count Cells that do not Contain Specific Text in Excel

In the previous post, we talked that how to count cell that contain certain text using the COUNTIF function in Excel. This post will guide you how to count the number of cells that do not contain specific text within a range of cells using a formula in Excel 2013/2016 or Excel office 365. How… read more »

How to Count Cells that Contain Specific Text in Excel

This post will guide you how to count the number of cells that specific text within a range of cells using a formula in Excel 2013/2016 or Excel office 365. How do I count the number of cells with certain text using a simple formula in Excel. When you analyze a large list of data,… read more »

How to Sum Data Every N Rows in Excel

Sometimes in statistic, data is grouped by every N rows, for example if data is grouped by week, then data is grouped every 7 rows (or columns in some cases). In our daily life, we may meet many cases like this. It is necessary for us to have the knowledge of sum data by every… read more »

How to Count Cells that Contain Text in Excel

This post will guide you how to count the number of cells that text only within a range of cells using a formula in Excel 2013/2016 or Excel office 365. How do I count the number of cells with text values(not errors, not numbers, not blanks) using a simple formula in Excel. When you analyze… read more »

How to Sum Entire Column or Row in Excel

No matter you are familiar or not familiar with excel functions, I think you must know SUM function, one of the most common used functions in excel. Generally, we often use SUM function to sum data in a fixed range in daily life. But if we want to sum entire column or row without boundary,… read more »

How to Count Cells that Contain even or odd numbers in Excel

This post will guide you how to count the number of cells that contain odd or even numbers within a range of cells using a formula in Excel 2013/2016.How do I count cells that contain odd numbers through the use of an Excel VBA Macro. Count Number of Cells that Contain Even Numbers Assuming that… read more »

How to Count Cells that Contain only numbers in Excel

This post will guide you how to count the number of cells that only contain numbers within a range of cells using a formula in Excel 2013/2016. Count Number of Cells that Contain Numbers Assuming that you have a data list in the range of cells B1:B6, and you want count the number of cells… read more »

How to Count Cells that Contain negative Numbers in Excel

This post will guide you how to count the number of cells that contain negative numbers within a range of cells using a formula in Excel 2013/2016.You can count the number of negative numbers in your data using easy functions in Excel. And the below will show you two ways in which you can count… read more »

How to Count Number of Cells that Contain Errors in Excel

This post will guide you how to count the number of cells that contain errors within a range of cells using a formula in Excel 2013/2016.You can easily to count cells equal to a specific value or text string through COUNTIF function. But if there is an easy way to count cells contain errors in… read more »

How to Sum Data Based on Criteria Adjacent Columns in Excel

In previous articles, we have introduced you some ways to sum data by group, month, weekday, week number etc. Actually, in our work life, we may meet some situations a bit more complex than above-mentioned cases. Depends on different situations, we may sum data by applying different formulas within different excel functions. Sum Data Based… read more »

How to Count Cells that Contain X or Y in Excel

This post will guide you how to count the number of cells that contain X or Y in a given range cells using a formula in Excel 2013/2016.You can easily to count cells equal to a specific value or text string through COUNTIF function. But if there is an easy way to count cells contain… read more »

How to Count Cells Are Not Blank or Empty in Excel

This post will guide you how to count cells that are not blank or empty in a given range cells using a formula in Excel 2013/2016.How do I count the number of cells that are not blank in a particular range with a VBA macro in Excel. You should know that excel offers several count… read more »

How to Sum by Week Number in Excel

In statistic report, we often statistic data for a certain date range. Sometimes we can use an exact week number instead of entering a start date and an end date as a period to statistic data. For example, to sum data by week 1, that means we only need to calculate data belongs to week… read more »

How to Count Blank or Empty Cells in Excel

This post will guide you how to count blank or empty cells in a given range cells using a formula in Excel 2013/2016.How do I count the number of cells that are blank in Excel. You should know that excel offers several count functions to count the number of cells in a selected range of… read more »

How to Count Cells That Begin with Specific Text in Excel

This post will guide you how to count cells that begin with a specific text string in a given range cells using a formula in Excel 2013/2016.How do I count cells the number of cells that begin with a certain text string in Excel. Count Cells that Begin with Specific Text Assuming that you want… read more »

Sidebar