Excel Sumifs

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 »