Tag: Formulas
-
How to use VLOOKUP in Excel
To use VLOOKUP, you have to first understand what it does and how it works. Then we will get to actually using it. What does VLOOKUP do in Excel The VLOOKUP function retrieves the value of a target cell located a specified number of columns to the right of a reference cell. The format of…
-
The SUM Function in Excel
If you need to add bunch of numbers, type in =SUM( in a cell, and select the numbers you want to add. How to use the SUM Formula in Excel After typing =SUM(, you can either click on individual numbers or drag across and array of numbers you want to add. When clicking on individual…