Excel Formulas Archives

How to Use SUMIFS formula with Multiple Criteria in Excel (11 Ways)

Dec 2, 2021 Excel Formulas

If you are looking for some of the easiest ways to use the SUMIFS formula with multiple criteria, then you will find this article useful. Sometimes ...

How to Use SUMIF with OR Logic in Excel (10 Methods)

Dec 2, 2021 Excel Formulas

By using the SUMIF function you can sum values based on a single condition or criteria like other cells being equal to either one value or another. ...

How to Sum Between Two Numbers Formula in Excel

Dec 2, 2021 Excel Basics

Every now and then we need to find out the sum of data for a range between two numbers in Excel. In this article, we use functions such as SUMIFS, ...

SUMIFS Sum Range Multiple Columns in Excel(6 Easy Methods)

Dec 1, 2021 Excel Basics

Often, we come across instances where we need to sum range spreading multiple columns. In this article, we use functions such as SUM, SUMIF, SUMIFS, ...

How to Do SUMIF Date Range Month in Excel (9 Ways)

Dec 1, 2021 Excel Formulas

If you are looking for some of the easiest ways to do SUMIF date range month, then you are in the right place. For calculating records of sales or ...

How to Remove Empty Rows in Excel (11 Methods)

Dec 1, 2021 Excel Formulas

In a large worksheet, there remains a possibility of having empty rows. From this article, you will get to know how to remove empty rows in excel. ...

How to Create and Use ColorFunction in Excel

Nov 30, 2021 Excel Formulas

In Excel, there is no function to make calculations based on the color of the cells. But by using Microsoft Visual Basic for Applications (VBA) it is ...

Excel Create Dynamic List from Table (3 Easy Ways)

Nov 30, 2021 Excel Basics

In general, lists are made by extracting entries from a dataset. If the lists update automatically then the lists are dynamic lists. In this article, ...

Excel Formula to Get First 3 Characters from a Cell(6 Ways)

Nov 30, 2021 Excel Formulas

Sometimes when data is copied from another source then there is a possibility of having a couple of information compact together. For this type of ...

How to Remove Blank Lines in Excel (8 Easy Ways)

Dec 2, 2021 Excel Formulas

If your Excel dataset contains unnecessary blank lines or empty rows, you may need to remove those. In this article, I will introduce you to 8 easy ...

How to Separate Two Words in Excel (6 Easy Ways)

Nov 29, 2021 Excel Basics

Separating two words in Excel is quite handy in order to extract data from a dataset. In this article, we use LEFT, RIGHT, LEN, SEARCH, FIND ...

How to Convert Text to Date in Excel (10 ways)

Nov 29, 2021 Excel Formulas

If you are looking for some of the easiest ways to convert text to date in Excel, then you will find this article useful. So, let’s dive into the ...

How to Split a Cell into Two Rows in Excel (3 ways)

Nov 29, 2021 Excel Formulas

If in a large dataset multiple information are compacted in one cell, then it is hard to find and lookup data to view or to do any task. In this ...

Excel Transpose Formulas Without Changing References (4 Easy Ways)

Nov 29, 2021 Excel Basics

Transpose data means data in Excel's rows are shifted in Excel’s columns where auto-update is necessary or not. Transposing formulas is the same as ...

How to Compare Addresses in Excel (11 Easy Methods)

Nov 28, 2021 Excel Formulas

To perform any data analysis task comparing data in excel rows is common. It is most required for banks to check the background of a customer ...