Invoice template that Calculates Total in Excel Office 365!!
Tags: excel, exceltemplates
Published: 2020-12-30 15:52:59

---
title: Invoice template that Calculates Total in Excel Office 365!!
published: true
date: 2020-12-25 12:36:42 UTC
tags: Excel,ExcelTemplates
canonical_url: https://geekexcel.com/invoice-template-that-calculates-total-excel/
---

An invoice template is helpful in calculating the total value, and you need not do it manually. It is a very simple invoice template for your business, you can download it for free. Here, we are going to see the **invoice template that calculates the total 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)

## Invoice Template that Calculates Total – Description:

Here, we will show the sample image of the invoice template in Excel.

!["<yoastmark](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/invoice-template.png)

### Total Items:

- It will count the number of cells that contain numbers in the range E5:E11.
- In cell E12, it contains the below formula for total calculations.

**=”Total items: “&[SUBTOTAL](https://geekexcel.com/excel-subtotal-function-in-office-365-with-examples/)(103,[Description])**

- Here, 103 means that the subtotal function will call the Excel [COUNT](https://geekexcel.com/how-to-use-excel-count-function-in-office-365-with-examples/) function.

### Subtotal:

- The Subtotal will calculate all item’s total value and returns it to the **cell H12**.
- Let’s see the below formula to calculate the total value.

**=[SUBTOTAL](https://geekexcel.com/excel-subtotal-function-in-office-365-with-examples/)(109,[Amount])**

- Here, 109 means that the subtotal function will call the Excel [SUM](https://geekexcel.com/sum-function/) function.

### Sales Tax:

- The default tax rate is 0 in this invoice template.
- You can change the tax rate in **cell**  **H30**.
- If you don’t want to calculate the sales tax, you can leave as blank.

### Total:

- The total amount will be automatically calculated in **cell H15** by using the below formula:

**=[IFERROR](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/)((Invoice[[#Totals],[Amount]]+SalesTax)-Deposit, “”)**

- You need to enter your company information at the bottom of the invoice template such as: company logo, name, address. Contact information, etc.
- Don’t forget to enter your customer details in a range **B3:B14** and you need to enter the invoice number in **Cell H1**.

## Get a free Invoice Template that Calculates the Total in Excel:

- Excel has a built-in invoice template for calculating  the total, you can easily customize and use it.
- Let’s do follow the below steps to get this template in Excel.
- First, you need to click the”File” tab and select the “New” option.

![Select New](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-New.png)<figcaption id="caption-attachment-20423">Select New</figcaption>

- Then enter “ **invoice that calculates total** ” in the search box.

![Select the template](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-template.png)<figcaption id="caption-attachment-20424">Select the template</figcaption>

- Finally,  you need to **click**  the  **Create** button to create a new workbook based on this invoice template.

## Wrap-Up:

From this tutorial, you can easily understand the usage of the **invoice template that calculates the total in Excel** with brief explanations. Mention your **queries** in the **comment** box below. We will assist you. Thank you so much for visiting our site!!

### Related Articles:

- **[Excel Formulas Used to Calculate the Subtotal by Invoice Number!!](https://geekexcel.com/excel-formulas-used-to-calculate-the-subtotal-by-invoice-number/)**
- [**Formulas to calculate the running total from a range in Excel!!**](https://geekexcel.com/formulas-to-calculate-the-running-total-from-a-range-in-excel/)