# Formulas

## Calculate a Running Total in Excel

This tutorial will teach you how to set up and calculate a running total with Excel. To calculate a running total, you’ll need to use the SUM function with a combination of absolute and relative references. Mixed references will allow you to create a growing total that is anchored to the initial value. Let’s start…

## Count if Cells in Range

This tutorial explains how to count the number of cells containing numbers that fall within a specified range using the COUNTIFS function. COUNTIFS COUNTIFS(range_1,criteria _1,[ range_2,criteria _2],…) range_1 (required): group of cells to count criteria_1 (required): conditions used to count range_2,criteria_2: optional ranges and criteria than can be evaluated. Up to 127 range and criteria…

## How to Calculate Age in Excel

This tutorial covers how to calculate age in Excel. Calculate Exact Age To calculate the exact age of a person, you want to calculate the difference between the current date (or any other desired date) and the birth date. You might think that you could simply take the difference in days between the current date…

## How to Calculate a Ratio in Excel

This tutorial will show you how to compare two numbers and calculate their ratio, such as 5:7 or 8:3. Calculate a Ratio – The GCD Method The GCD Function is used to calculate the greatest common denominator between two or more values. We can use GCD to then create our ratios. To use the GCD…

## Compound Interest Formula in Excel

This tutorial will demonstrate various ways to calculate compound interest in Microsoft Excel. What is compound interest? When you invest money, you can earn interest on your investment. Say, for example, you invest \$3,000 with a 10% annual interest rate, compounded annually. One year from the initial investment (called the principal), you earn \$300 (\$3,000…