All Microsoft Excel Versions

Summing Values Based on the Criteria of a Non-Empty Adjacent Cell

While working on reports, you want a formula that will give you a sum of values based on the criteria of a corresponding non-empty cell. You can fi...

Summing Annual Expenses by Respective Quarters

If you want a formula that will give you total of the expenses incurred in a quarter based on the value in the corresponding cell. You can use a co...

How to Sum Values based on Numerical & Textual Substring in Microsoft Excel 2010

  To find the sum of values from a list containing numerical & textual excel substring, we will use a combination of "SUM", "IF", "ISNUMBE...

Summing the Visible Filtered List in Excel 2010

To get the total of the values in the visible filtered rows only, we can use the SUBTOTAL function to retrieve the output. SUBTOTAL:Returns a subtota...

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

Sum Across Multiple Sheets in Microsoft Excel

In this article we will learn how to add cells from different sheets in Microsoft Excel. Consider a scenario while working on the reports you want a...

Separating A String Into Excel Substring

While working on reports, you may want a formula that will derive results from a string into substrings. You can use a combination of MID & ROW...

Retrieving a Value from a Reference Grid, Using Indexes Listed in another Range

In this article we will learn how to find a value from a reference grid while using indexes list, we can use a combination of "OFFSET" & "MATCH" f...

Retrieving the Column Header of the Largest Value in a Row in Excel 2010

In this article we will learn how we can retrieve the column header of the largest value in a row in Excel 2010. If you want to recover the column ...

Page 21 of 105« First...10...1920212223...304050...Last »
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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube