Sum Formula in Microsoft Excel

In this article we will learn how and where we can use Sum formula in Microsoft Excel. To add the figures at the intersection of two or more ranges, ...

Summing data by selecting cells in Microsoft Excel

To obtain the sum of the data by selecting range of cells, we can use SUM function to get the output.   SUM: Adds all the numbers in a range ...

How to Sum Across Multiple Sheets in Microsoft Excel

In this article, we will learn how to get the sum or add cells across multiple sheets in Microsoft Excel. Sometimes we need to access different val...

Summing in MS EXCEL 2010 – New Features Unraveled

Microsoft Excel is one of the majorly used tools of MS Office for organizing data and creating graphical statistical analysis. The 2010 professional v...

How to Sum the N Largest Values in a Range in Excel

In this article, we will learn How to Sum the N Largest Values in a Range in Excel. Scenario: In simple words, while working with data numbe...

Summing Sales Amounts According to Product Category and Customer Name

Problem: Columns A:C contain product categories, customer names, and prices paid for various items. When using the following formula to sum the pric...

Creating a List in which Each Number is the Sum of the Previous N Numbers

Problem: We want to create a sequence of numbers where each member of the sequence is the sum of the previous N number of values. Solution: U...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.