## Running Total (Cumulative SUM)

This tutorial will show you how to calculate the running total (cumulative sum) in Excel using the RTOTAL function.

## Sum every nth column

Learn how to sum every nth column (for example, every second, third, or fifth column) using the Excel SUMCOLUMNS function.

## Sum every n rows

Learn how to sum every n rows down in Excel using the SUMN_ROWS function or regular (SUM, OFFSET) functions.

## Get the nth value in a column

This quick guide will show you how to get the nth value in a column using the CHOOSEROWS function in Excel.

## Return the Nth Value in a Row

In this tutorial, you will learn how to return the nth value in a row using the CHOOSECOLS Excel function.

## How to extract number from string in Excel

Learn how to extract a number from a text string in Excel (from the left, right, or any position) using custom formulas and functions.

## MEDIAN IF Formula

Learn how to use the MEDIAN IF array formula to identify the middle number of values that meet specific criteria.

## Lookup and return the nth value using NVLOOKUP

Learn how to lookup and return the nth value (or the second, third or nth match) in Excel using the NVLOOKUP function.

## Lookup and return multiple values in one cell

To return multiple lookup values in one cell in Excel separated by a comma, use the MLOOKUP or MLOOKUP_NR functions.

## How to SUM top N values in Excel

To sum the largest n values in a range – sum top n values in Excel – you can use the SUMHIGH function.

## Convert Date to Number [or Number to Date] in Excel

Learn how to convert a date to a number or convert a serial number to a date using Excel.

## VLOOKUP multiple matches

This Excel guide will show you how to return and display multiple matches using the VLOOKUP function.