One of the most crucial mathematical tools is **integral**. 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.

## Download Practice Workbook

Download the practice workbook from here.

## 2 Handy Approaches to Do Integration in Excel

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. For describing 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**.

**Read More:** **How to Do Trapezoidal Integration in Excel (3 Suitable Methods)**

## 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. Follow our website **ExcelDemy** to get more articles like this.