Invoice Template that Calculates Total in Excel Office 365!!
Tags: exceltemplates, invoicetemplatethatc
Published: 2021-01-12 03:47:12

---
title: Invoice Template that Calculates Total in Excel Office 365!!
published: true
date: 2020-12-28 15:10:35 UTC
tags: ExcelTemplates,InvoiceTemplatethatC
canonical_url: https://geekexcel.com/invoice-template-that-calculates-total-in-excel-office-365/
---

The invoice template in Excel is used to calculate line item total and payment details. Excel has many templates regarding invoice template. You can use it for free. It is very easy to customize and use. Let’s see the usage of the **Invoice Template that Calculates Total in Excel Office 365**.
## Invoice Template that Calculates Total:

Here, we will show you the formulas and its description that are used in this template.

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

### Total Items:

- It will count the number of cells that contain numbers in a range **F7:F31**.

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

- **103** – This value means that the [**Subtotal function**](https://geekexcel.com/excel-subtotal-function-in-office-365-with-examples/) will call the **[COUNT](https://geekexcel.com/how-to-use-excel-count-function-in-office-365-with-examples/)** Function.

### Subtotal:

- This will calculate all item’s total amount automatically in **cell 132.**

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

- **109** – It means that the subtotal function will call Excel **[SUM Function](https://geekexcel.com/sum-function/).**

### Sales Tax:

- The default **tax rate** is **5.0%** in this invoice template. You can change the value of the tax rate in **Cell F34.**
- If you don’t want to use it, just leave it.

### Total:

- The total amount will be calculated in cell **E28** by using the below-given formula.

**=(tblInvoice[[#Totals],[Amount]]+SalesTax)-Deposit**

**tblInvoice – ** It is the name of the range that refers to **“=’Simple Invoice’!$E$7:$i$31”**

You can enter your company information at the bottom of the invoice template like company logo, company name, phone number, and so on.

## Use Free Invoice Template on Excel:

- Excel provides a free Invoice Template, you can make use of it.
- To get this template, you need to **click** the **File Tab** and **select** the **New** option.

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

- Then you have to **enter the invoice**  **that calculates the total** in the **search**  box and click the result.

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

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

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

## A Short Summary:

In the above article, you can easily learn the usage of **Invoice Template that Calculates Total in Excel Office 365** with its description and example. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!