Integration is One of the most crucial mathematical tools. We can use it to compute area, volume, and many other beneficial metrics. We can also use it when examining data from machinery or equipment that collects a lot of measurements. This article will go through how to do integration in Excel in some easy ways.

**Table of Contents**Expand

## How to Do Integration in Excel: 2 Handy Approaches

In this article, we are going to discuss **2** handy approaches to do **integration** in Excel. Here, we have used **the SUM function** both individually and after using **the ABS function**. So, without further delay, let’s see the approaches below.

### 1. Apply Excel SUM Function to Do Integration

In this method, we will use the **SUM** function in Excel to calculate the **integral** values. To describe this method, we have used a dataset (**B4:D9**) in Excel that contains the values which are needed to calculate the **Area of a Trapezoid**. Here, we will use the **SUM** function in Excel to find the **integral** below:

The steps to do so are below.

**Steps:**

- Firstly, set the
**height**of the trapezoids (**dx**). In this example, let’s call it**Height**and set it to**0.2**in cell**C12**. - Secondly, set the values of
**a**from**0**to**1**with the specified**Height**step.

- Thirdly, to calculate the value of
**b**, type the formula in cell**C5**:

`=B5^2+3*B5^3+2`

- After that, press the
**Enter**key and then drag the**fill handle**below to get all the**b**values.

- Next, to calculate the
**Area of Trapezoid**type the below formula in cell**D6**.

`=0.2/2*(C5+C6)`

- Afterward, press the
**Enter**button and drag the**fill handle**to get all the values of the**Area of Trapezoid**.

- Then, to calculate the
**Definite Integral**, type the formula below in cell**C13**.

`=SUM(D6:D10)`

Here, the range **D6:D10** indicates the values of the **Area of Trapezoid**.

- Finally, click on the
**Enter**key to get the**Definite Integral**.

### 2. Integration of Large Data Sets Using ABS & SUM Functions in Excel

In this method, we will learn the steps to **integrate** a **large** data set using both the **ABS** and the **SUM** functions. For this, we have used a dataset (**B4:G8**) that contains the values of **water content** (**B5:B8**) and **Dry Density** (**C5:C8**) from a **dry density** vs **water content** chart. Here, we need to calculate the area under the curve (**Integral Value**) by using the **ABS** & **SUM** functions. Let’s see the steps below.

**Steps:**

- First, select the columns representing the
**width**and**height**of the**trapezoid**. Here, we selected**w(%)**as width (**w**) and**Dry Density**as height (**h**). Here, we assumed that the area under the curve is divided into some**trapezoidal**areas. - Next, to calculate the width (
**w**) of the first**trapezoid**, click on cell**D5**and type the formula:

`=ABS(B6-B5)`

- Then, to find all the
**w**values press**Enter**and drag the**fill handle**up to the cell**B15**.

- Subsequently, to calculate the
**height**(**h**) of the first trapezoid, select cell**E5**and type the formula below:

`=0.5*(C5+C6)`

- Consequently, press the
**Enter**key and drag the**fill handle**up to the cell (**E7**) before the last cell of the dataset.

- Afterward, to compute the area (
**A**) of each trapezoid, type the formula below in cell (**A5**):

`=D5*E5`

- After pressing the
**Enter**key and then dragging the**fill handle**up to cell**A7**, we’ll get the areas (**A**) of each trapezoid.

- Now, to find the desired
**Integral Value**, go to cell (**G5**) and then type the formula below:

`=SUM(F5:F7)`

In this formula, the range **F5:F7** refers to the areas (**A**) of each **trapezoid**.

- Lastly, press
**Enter**. - In this way, we can calculate the desired
**Integral Value**.

**Download Practice Workbook**

## Conclusion

I hope the above methods will be helpful for you to do integration in Excel. Download the practice workbook and give it a try. Let us know your feedback in the comment section.

**<< Go Back to | Calculus in Excel | Excel for Math | Learn Excel**