Category: Excel
-
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…
-
How to use COUNT and COUNTA in Excel
The Count function in Excel is used to count the number of values in a selection of cells. How to use COUNT in Excel Type =Count( in a cell and select the cells you want to count for numerical entries. After selection, close the bracket with ) and hit enter. The cell you entered the…