### SUMIF vs SUMIFS in Excel

While working with Microsoft Excel, the SUM function is one of the essential functions that everyone uses. We use this function in a lot of ...

### Excel Formula to Split: 8 Examples

Excel formula helps us to split a cell or a text string or a column. This makes the dataset more readable and easily accessible to the correct ...

### Macro to Delete Row in Excel If Cell is Blank

In this article, I’ll show you how to develop and run a Macro in Excel to delete a row if the cell is blank. You’ll learn all the steps from opening ...

### Lookup Value in a Range and Return in Excel (5 Easy Ways)

If you want to look up certain criteria in a range and find the matching value, this article is the right place for you. I’ll show you 5 easy ways to ...

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

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)

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 Bulk Convert Text to Number in Excel (6 Ways)

Sometimes the numbers in your worksheet don’t act like numbers; they don’t execute any kind of arithmetic operations as they should, they even may ...

### How to Remove Empty Rows in Excel (11 Methods)

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

### Convert Text to Date and Time in Excel (5 Methods)

In Excel, we mainly work with data. We organize and manipulate data as per our requirements. We find out the required information from our managed ...

### Excel VBA Code to Delete Rows Based on Multiple Cell Value (3 Criteria)

In this article, I’ll show you the VBA code to delete rows in Excel based on multiple cell value. You’ll learn to delete rows when multiple cells ...

### Excel Formula to Split One Column into Multiple Columns (4 Examples)

Excel formulas help us to find value from a long column by splitting one column into multiple columns. These make the dataset more readable and ...

### How to Create and Use ColorFunction in Excel

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 SUMIF with a Date Range in Month & Year (4 Examples)

Working with date-based data is one of the most common uses of Microsoft Excel. We perform various calculations based on dates. We use various ...

### How to Use SUMIFS with Date Range and Multiple Criteria (7 Quick Ways)

Working on Excel, you may often need to sum numbers within specific dates. This article will provide you with 7 quick methods to apply the SUMIFS ...

### How to Calculate Years Between Two Dates in Excel (2 Methods)

It is quite a common incident to work with dates while working in Excel. Very often we may need to calculate dates or years between two given dates. ...