Quickly sum non-contiguous cells

Sometimes you may want to calculate the sum of a group of non-continuous or non-contiguous cells.  Do you enter in each cell address like =A2+C2+G2+I...

Iteration in Excel 2007

To intentionally use a Circular Reference: In this example, a Value-added tax (VAT) gross-up formula is in cell B1 (the formula is =B3-B2). 1. In ...

How to use the BITLSHIFT Function in Excel

IN this article, we will understand How to use the BITLSHIFT Function in Excel Scenario: This function was introduced in Excel 2013 and it r...

How to use the BITXOR Function in Excel

In this article, we will learn about how to use the BITXOR function in Excel. Scenario: BITXOR function in excel perform the BITWISE XOR ope...

How to use the XOR function in Excel

In this article, we will learn about how to use the XOR function in Excel. In simple words, logic_test are performed in excel to perform an action ...

How to Delete Range Name in Excel

In Microsoft Excel if you want to remove named range, it is a very simple task. First, let’s create a Name Range so that we can understand it in a b...

Finding a substring within a string

Problem: Determining whether the strings in column C contain the corresponding substrings in column D. Solution 1: Using the COUNTIF function in ...

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.