SUMIF Function

How to Sum Selected Cells in Excel (4 Easy Methods)

If you are looking for some special tricks to sum selected cells in Excel, you've come to the right place. In Microsoft Excel, there are numerous ...

How to Calculate Average of Multiple Columns in Excel (6 Methods)

In this tutorial, I will show some methods regarding calculating the average of multiple columns in Excel. Usually, you can get an average of a range ...

[Solved!] Excel Sort Not Working (2 Solutions)

Sorting data is one of the easiest and most frequently used operations in MS Excel. What if the Sort Command doesn’t work properly? This article will ...

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

How to Use Greater Than or Equal to Operator in Excel Formula

In Excel, the logical operator “greater than or equal to” is used to collate two data cells of matching data type. The sign “>=” is used to ...

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

How to Sum by Group in Excel (4 Methods)

To sum by group means to add up values of a particular category. We often use it on numerous occasions in our daily lives. The summation of a group ...

How to Apply ‘If Greater Than’ Condition In Excel (9 Ways)

While working with a big data set, we frequently need to compare numbers. In some cases, we need to find the summation, average or conditional ...

How to Sum Only Visible Cells in Excel (4 Quick Ways)

There are a few ways to Sum Only Visible Cells in Excel. Today we will go through 4 quick ways to Sum Only Visible Cells. Frequently, we need to hide ...

How to Sum Only Positive Numbers in Excel (4 Simple Ways)

We can easily Sum a range of Excel datasheets. But, quite frequently we need to add the cell values following a condition. This article will show you ...

How to Calculate Cumulative Sum in Excel (9 Methods)

The Cumulative Sum is very commonly performed in Excel by many people all over the world. It is often called the Running Total/Balance. The ...

How to Calculate Running Balance Using Excel Formula (4 Ways)

Keeping a running balance of your checking and credit accounts is one of the most critical chores in personal finance, and spreadsheets are a popular ...

How to Perform Greater than and Less than in Excel (5 Methods)

Operators specify the type of calculation that you want to perform on the elements of a formula. There are four different types of calculation ...

How to Use Excel Table Reference (10 Examples)

If you are looking for some of the easiest ways to use Excel Table reference, then you are in the right place. Using Table references you can perform ...

ExcelDemy
Logo