Excel Formulas to Lookup and Sum Column ~ With Clear-Cut Example!!
Tags: excelformula, excelformulas
Published: 2021-01-18 03:57:47

---
title: Excel Formulas to Lookup and Sum Column ~ With Clear-Cut Example!!
published: true
date: 2021-01-11 04:11:08 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-lookup-and-sum-column/
---

Using the **[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)** and **[SUM](https://geekexcel.com/sum-function/)**  function you can quickly find out the specified criteria and sum the corresponding values at the same time. In this article, we are going to show you **how to**  **Lookup and sum the values from a column in Excel**? Let’s get started!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Lookup and sum the columns](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/lookup-and-sum-columns.png)](https://geekexcel.com/?attachment_id=20876#main)<figcaption id="caption-attachment-20876">Lookup and sum the columns</figcaption>
## General Formula:

- The formulas in this section can help to sum the first or all matched values in a column based on specific criteria in Excel.

**=[SUM](https://geekexcel.com/sum-function/)([INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(data,0,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(value,header,0)))**

## Syntax Explanations:

- **SUM** – In Excel, the **[SUM function](https://geekexcel.com/sum-function/)** will help to add the values in the cell.
- **INDEX** – The **[INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)** returns the value at a given position in a range or array.
- **MATCH** – In Excel, this function will locate the position of a lookup value in a row, column, or table. Read more on the **[MATCH function](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)**.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Data** – It represents the input ranges in your worksheet.
- **Values** – It is the criteria that want to get the values.
- **Header ** – The header is the given input headings from your worksheet.

## Example:

Refer to the below example image.

- Here, we will give the input values in **[Column](https://geekexcel.com/excel-office-365-columns/) B** to **Column F**.

![Input Ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-Ranges-6.png)<figcaption id="caption-attachment-20872">Input Ranges</figcaption>

- Now, we are going to find the sum of the C1 column from the worksheet.

![Criteria](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Criteria-6.png)<figcaption id="caption-attachment-20873">Criteria</figcaption>

- **[Enter the given formula](https://geekexcel.com/how-to-enter-formula-in-excel/)** in cell I3, you can also see it in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** section.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-the-formula-5.png)<figcaption id="caption-attachment-20874">Enter the formula</figcaption>

- After applying the formula it will add the value under the C1 header and returns it to the selected **[cell](https://geekexcel.com/excel-cells-options/)**.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-17.png)<figcaption id="caption-attachment-20875">Result</figcaption>

## Bottom-Line:

Here, we explained the simple formula used to **lookup and sum the entire column in Excel** with a clear-cut example. Please share your **query** below in the **comment** box. We will assist you. To learn more, check out **[Geek Excel!!](https://geekexcel.com/)**  and  **[Excel Formulas](https://geekexcel.com/excel-formula/)!!** Thank you ![🙏](https://s.w.org/images/core/emoji/13.0.1/72x72/1f64f.png)

### Read Ahead:

- **[Excel Formulas to Sum columns based on Adjacent criteria!!](https://geekexcel.com/excel-formulas-to-sum-columns-based-on-adjacent-criteria/)**
- **[Excel Formulas to Sum the Values from the Matching Columns!!](https://geekexcel.com/excel-formulas-to-sum-the-values-from-the-matching-columns/)**