SUM Function Archives

How to Show Total in Excel Pie Chart (2 Quick Ways)

Jan 26, 2023 Excel Charts

Microsoft Excel facilitates us with various types of charts. Among them, the Pie Chart, also known as a circular graph, is an excellent way to show ...

How to Create Fuel Cost Calculator Using Excel Formula

Jan 26, 2023 Calculation with Excel Formulas

In this article, we are going to create a Fuel Cost Calculator using Excel formula. Here, we are going to give you a very easy way to find out the ...

How to Count Unique Values in Excel with Multiple Criteria

Jan 25, 2023 Excel Formulas

In this article, we will show you some methods to count unique values in Excel worksheet based on different criteria. The Excel worksheet can be used ...

How to Ignore Blank Cells in Excel Sum (6 Ways)

Jan 25, 2023 Excel Basics

This article will show you how you can ignore blank cells in Excel sum. In the spreadsheet, sometimes we have to sum a data range that has blank ...

How to Create Reverse Mortgage Calculator in Excel

Jan 25, 2023 Calculation with Excel Formulas

Senior citizens in many countries can utilize their home’s equity to obtain cash. This process is known as the reverse mortgage. In this article, we ...

How to Use LARGE and SMALL Function in Excel (3 Examples)

Jan 25, 2023 Excel Formulas

If you want to find the 3rd most expensive smartphone from a list of smartphones, or you’re searching to solve a problem like this, you’re on the ...

How to Use SUMIF and ISBLANK to Sum for Blank Cells in Excel

Jan 18, 2023 Excel Formulas

In this article, you will learn how to SUMIF values with the ISBLANK function in Excel. Sometimes, in the dataset, we have empty cells to check and ...

How to Create Bill Book in Excel (2 Easy Ways)

Jan 15, 2023 Excel Formulas

Book Bill contains information regarding the purchased products and shows the overall bill. Likewise, businessmen need to create bill books for their ...

How to Plot Cumulative Histogram in Excel (with Easy Steps)

Jan 16, 2023 Excel Charts

A histogram is one kind of graph which we use to show frequency distribution within some prespecified ranges. These data ranges are called ‘bins’. ...

How to Perform Interest Rate Swap Calculation in Excel

Jan 9, 2023 Calculation with Excel Formulas

With the aid of a financial derivative called an interest rate swap, two parties can exchange the cash flows from a fixed-rate loan for the cash ...

Check If Cell Contains Text Then Return Value with Multiple Conditions in Excel

Jan 10, 2023 Excel Formulas

Looking for ways to check if a cell contains text and then return value with multiple conditions in Excel? Then, this is the right place for you. ...

How to Change Font Within Formula in Excel (3 Easy Ways)

Jan 5, 2023 Excel Formulas

Looking for ways to change font within formula in Excel? Then, this is the right place for you. By changing the font within the formula, you may make ...

How to Use Dividend Discount Model Formula in Excel

Jan 10, 2023 Excel Formulas

The Dividend Discount Model Formula determines the stock price based on the probable dividends one will pay. It helps to evaluate a company based on ...

[Fixed!] Null Error in Excel (3 Possible Solutions)

Jan 8, 2023 Excel Basics

In this article, we will discuss reasons for Null Error in Excel and their possible solutions. Null Error occurs when we forget to use a comma or ...

How to Use OFFSET for Cell Reference in Excel (5 Easy Ways)

Jan 4, 2023 Excel Basics

If you are looking for some special tricks to know how to use OFFSET for cell reference in Excel, you've come to the right place. We’ll show 5 ...