Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SUM Function

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

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

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

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)

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

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)

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

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)

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)

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

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

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)

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

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)

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)

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 ...

ExcelDemy
Logo