Excel Sumifs

How to Sum if Cell Contains Text in Another Column

We often sum data based on criteria. To sum values based on a cell, in fact, we sum values based on the text in this cell. If the text is included in another table another column, we need to find out all locations of this text in this column, and then sum up all matched… read more »

How to Sum Data if Between Two Numbers in Excel

For a set of data, if we want to sum data for a range between two numbers, we need to sum data based on ‘> criteria A and < criteria B’, so there are two criteria here. In our daily work, this case frequently occurs when calculating total score or total amount for a range…. read more »

How to Sum Data if Begins with/End with/Contains in Excel

For a set of data, sometimes we may need to sum some of them based on criteria ‘if begins with/end with/contains’ ** characters. In our daily work, this case frequently occurs when calculating total for one or more items among a lot of different type of items. To resolve this problem, we can apply excel… read more »

How to Count Specific Items in List in Excel

This post will guide you how to Count Cells that contain a apecific string of text using a formula in Excel 2013/2016 or Excel office 365.How do I create a count of the values that appear in a list or table in Excel. And this post will show you how to use the COUNTIFS function… read more »

How to Count the Cells that Match Two Criteria in Excel

This post will guide you how to Count Cells that match two or more criteria in the range of dates using a formula in Excel 2013/2016 or Excel office 365.How do I count on two or multiple criteria or you want to count something in a range of cells only if two or three conditions… 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 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 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 Values Based on Month and Year in Excel

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 »

Sum Values by Group

This post will guide you how to sum data by group in a table in Excel. Assuming that you have a table that contain the product name and its sales result. And you have group by those values based on the product name, then you want to sum values based one each product name. You… read more »

Excel SUMIFS Function

This post will guide you how to use Excel SUMIFS function with syntax and examples in Microsoft excel. Description The Excel SUMIFS function sum the numbers in the range of cells that meet a single or multiple criteria that you specify. You can use the SUMIFS function to sum cells that based on the dates,… read more »

Sidebar