SUMIF Function Archives

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

Apr 27, 2022 Excel Formulas

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)

May 24, 2022 Excel Basics

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)

Mar 6, 2022 Excel Basics

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)

May 23, 2022 Excel Basics

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)

May 23, 2022 Excel Basics

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

May 22, 2022 Excel Basics

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

May 22, 2022 Excel Basics

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)

Mar 29, 2022 Excel Basics

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)

May 22, 2022 Excel Basics

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)

May 23, 2022 Excel Basics

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)

May 23, 2022 Excel Basics

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)

Mar 29, 2022 Excel Basics

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)

May 22, 2022 Excel Formulas

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)

May 22, 2022 Excel Basics

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)

May 22, 2022 Excel Basics

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