SUM Articles: Excel and Google Sheets

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...