All resources related to SUM for Excel and Google Sheets.

How to Figure Sum If Cells Are Equal to in Excel

Excel allows us to sum all values from a table that equal to the selected value by using the SUMIF function. This step by step tutorial will assist all levels of Excel users in summing values from the table with a certain condition. Figure 1. The final result of the...

Sum if cell contains text in another cell

When we want to add data based on a given criteria in Excel, it is best to use SUMIF or SUMIFS. This article will explain how to sum cells while looking up specific text in another cell. Figure 1. Final result: Sum if cell contains text in another cell Formula...

Sum If Cells Contain Specific Text

In Excel, we often need to sum cells if they contain specific text. In order to achieve this, we will use the SUMIF function which enables us to sum values from one column, while looking up for the specific text in another column. This step by step tutorial will assist...

Sum Bottom N Values with Criteria

Excel allows a user to sum bottom N values with criteria using the SUM, SMALL and IF function. The final formula has to be converted to array function with ctrl+shift+enter in order to work properly. This step by step tutorial will assist all levels of Excel users to sum the...

Sum if equal to one of many things

Excel allows a user to sum values if a cell is equal to one of many values from the other range, using the SUMPRODUCT and SUMIF functions. This step by step tutorial will assist all levels of Excel users in summing values if a cell is equal to one of...

Sum by Week Number

Excel allows us to sum the values based on the week number by using SUMIFS and WEEKNUM functions. This step by step tutorial will assist all levels of Excel users in summarizing the values based on the multiple criteria, including week number. Figure 1. Sum Amount by Week Number Syntax...

Sum sales in last 30 days by ID

Excel allows us to sum all values from a table with a date within the last 30 days using the SUMIFS and TODAY functions. This step by step tutorial will assist all levels of Excel users in summing sales in the last 30 days by ID. Figure 1. The final...

Sum if Multiple Criteria

Excel allows us to sum all values from a table that meet multiple criteria using the SUMIFS function. This step by step tutorial will assist all levels of Excel users in summing values if multiple criteria are met. Figure 1. The final result of the SUMIFS function Syntax of the...

Sum last n columns

In Excel, we are able to sum the last n columns of any data set by using the SUM, INDEX and COLUMNS functions. The SUM function adds all given values, the INDEX function returns a value or reference to a cell, while COLUMNS returns the number of columns in an...

3D Sum Multiple Worksheets

Excel allows us to sum the same cell ranges on the multiple worksheets by using SUM function with 3D reference syntax in the formula. This step by step tutorial will assist all levels of Excel users in summarizing the values in the same cell position on the several worksheets. Figure...