Excel formulas and tutorials

Excel formulas and useful tools

# Category: Excel

## Adding amounts greater than zero

By
|
In Useful formulas
|
On November 17, 2015
Adding amounts greater than zero or another given value in Excel is sometimes required and can be acquired by using the SUMIF or SUMIFS formulas. The formula for adding amounts greater than a given value =SUMIFS(sum range, sum range, “>0”) You can replace 0 with the value you need. The condition inside the formula can […]

## Find and delete duplicates in Excel

By
|
On September 16, 2015

In order to find and remove duplicates or just highlight them in an complex and messy Excel spreadsheet be prepared to work hard or just smart and elegant. Too many times we end up with an extralarge

## Format cell to show numbers in thousands

By
|
On September 16, 2015

Sometimes it is useful to round numbers to the nearest 1000 in order to obtain a good looking report. That is, to have many small width columns and get them all on the same page when printing. Formatt

## How to use Offset in a table

By
|
In Data analysis
|
On February 17, 2015
Need to find a value in a large table and you know only the label of the row and column where the target is located? No problem, Excel can help you do it with only two formulas: Offset and Match. Take a look in the picture bellow. You will find out how to do it. […]

## Zero if error or #N/A in Vlookup

By
|
On September 19, 2014

Sometimes the result of an excel formula is an element of a larger and sophisticated calculation which will end displaying an error if any of the elements taken into account is not a number. This is t

## Determining top rankings of amounts in a range

By
|
In Data analysis
|
On September 18, 2014
Sometimes we have to know the rankings of amounts in an array or range, in order to select some of them, let’s say top 10. Microsoft Excel comes to the rescue by offering a formula to count elements that have certain attributes or meet some conditions. This function is COUNTIF and it’s result is the […]

## Two formated values in the same cell

By
|
On September 16, 2014

Sometimes you need to insert two values into the same cell. Like having the profit variation in absolute terms and in percentages in a single cell. Different format for two values in a single cell The

This div height required for enabling the sticky sidebar