Excel Formula Examples

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 »

How to Sum/Extract Data by Month in Columns/Tables in Excel

In our daily work, sometimes we may get original data in a table provided by customer or partner without arrangement, and if we want to arrange data by month or other criteria like group or others, we need to sum/extract data based on data range and then sum data and list them into another table…. read more »

How to Sum by Week in Excel

At the end of work on Friday, we often summarize data based on daily report and create a weekly report, so sometimes we need to sum values by week for summary. Like sum data by month, we can use a formula contains SUMIFS function to sum data by week properly. This tutorial will show you… read more »

How to Sum by Month in Excel

If sum data by month in a table, we need to use a formula based on SUMIFS function. We can provide a set of conditions or criteria in SUMIFS function to sum data. To sum data by month, we need to add date range as criteria. Example: See below screenshot, if we want to sum… read more »

How to Sum by Group in Excel

Sometimes we may have the requirement that subtotal data by group in a table. To just subtotal data in a column, we can use SUM function directly; for data in a column, amount data in another column, we can use SUMIF function to subtotal data. But to subtotal data in group, we need to classify… read more »

How to Sum Data by Month Ignore Year in Excel

Sometimes we may want to sum data by month but ignoring the year. For example, if we want to investigate which month has the top sales among several years, we may sum data by month but ignoring the year information. Actually, we can use formula based on SUMPRODUCT function and MONTH function to sum data… read more »

How to Count Cells Not Equal to One of Many Things in Excel

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

How to Count Cells Not Equal to a Specific Value in Excel

This post will guide you how to count the number of cells that are not equal to a specific value in a given range cells using a formula in Excel 2013/2016. Is there an easy way to count cells which are not equal to a particular value in your working data in Excel. Count Cells… read more »

How to Count Cells Greater Than a Specific Value in Excel

This post will guide you how to count the number of cells greater than a particular numeric value in a given range cells using a formula in Excel 2013/2016. How do I count cells that are greater than a specific value through VBA Macro in Excel. Count Cells Greater Than a Specific Value Assuming that… read more »

How to Count Cells equal to one of many cells in Excel

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

How to Count Cells equal to X or Y in Excel

This post will guide you how to count the number of cells equal to criteria 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 through COUNTIF function. But if there is an easy way to count cells equal to either… read more »

How to Count Cells equals to Cells with Case Sensitive in Excel

This post will guide you how to count the number of cells equal to a specific value in a given range cells with case sensitive using a formula in Excel 2013/2016.you can easily to count cells equal to a specific value without case sensitive through COUNTIF function. But if there is an easy way to… read more »

How to Subtotal for Value in Specific Cell in Excel

Sometimes we may want to sum within some criteria in excel, actually, we can use SUMIF function directly instead of SUM for some special instance. For example, if we just want to get subtotal for one product among all products, we can use SUMIF function here to only calculate the total for the specific product… read more »

How to Auto Fill Weekdays or Weekends in Excel

Sometimes we may want to enter a sequence of days in excel for some purpose, and we can press Ctrl+; to insert current date into cell, and then drag the cell down to attach following days into other cells, then we can get a list of days. But for some special requirement, we just want… read more »

Sidebar