SUM Function

Excel Sort and Ignore Blanks (4 Ways)

By default, when we sort data in Excel, it leaves all the blank rows at the end. But we don’t always want this. Sometimes we need to ignore the ...

There is no direct multiply formula in Excel but no worries, there are other multiple ways to multiply in Excel. We can use Asterisk (*) which is ...

How to Link Two Workbooks in Excel (5 Methods)

Linking workbooks is necessary and effective in various ways. It is necessary when creating a summary or report from multiple data sources, merging ...

How to Calculate Total Row and Column in Excel (4 Methods)

While working with a large worksheet in Microsoft Excel, we need to sum up cells in Excel. To sum, cells values mean total columns and rows value, MS ...

How to Use VBA ChDir Function in Excel (4 Suitable Examples)

In Microsoft Excel, it’s easy to change the directory or folder by using VBA Functions. There are a total of nine File/Directory Functions. One of ...

How to Link Cells in Excel (7 Ways)

In Microsoft Excel, linking cells is one of the crucial tasks. You will face many instances where you may have to connect cells. When cells are ...

How to Insert a Clustered Column Chart in Excel

Without a doubt, charts in Excel are an outstanding tool to portray any data graphically instead of showing a complex table with lots of fields. More ...

How to Link Sheets in Excel with a Formula (4 Methods)

We can save a lot of time, minimize error rate and improve data integrity in Excel if we can properly Link Sheets. This article will cover the ...

How to Link Cells in Same Excel Worksheet (4 Quick Ways)

Excel worksheet provides us with many features that help us to organize our data easily. Sometimes, for better analysis, we require Link Cells in our ...

Highlight Cells That Contain Text from a List in Excel (7 Easy Ways)

In this tutorial, I will discuss how to highlight cells that contain text from a list in excel. I will use Conditional Formatting to highlight cells. ...

How to Sum Entire Column in Excel (9 Easy Ways)

Summing up is an important aspect of any datasheet in Excel. Sometimes, we need to sum the entire column in excel for effective data analysis. There ...

How to Total a Column in Excel (7 Effective Methods)

We store a huge amount of data in the Column of Excel sheets and most of the time we need to Total the Column. This article will show you the exact ...

51 Mostly Used Math and Trig Functions in Excel

The Math & Trig functions in Excel are very common in many mathematical calculations like- basic arithmetic, conditional sum & product, ...