Excel can perform an array of basic math functions and the articles listed below will show you how to create the necessary formulas to add subtract multiply or. Many times I needed to find the column number associated with a column letter in order to use it in Excel Macro. In this case we entered sum then.
First subtract the value in cell B1 from the value in cell A1.
Summary To lookup a value by matching across multiple columns you can use an array formula based on the MMULT TRANSPOSE COLUMN and INDEX. Below we will show you. Remember that you can also use the keyboard shortcuts CTRL SPACE to select an entire column or SHIFT SPACE an entire row. Select a cell next to the numbers you want to sum click AutoSum on the Home tab press Enter and youre done.