## Count cells not equal to x or y using COUNTIF

You can count all cells not equal to x or y using a simple COUNTIFS formula. If you only want to count using one condition, then you can also use COUNTIF as an alternative. I’ll explain both in this...

## How to use IF function with 3 conditions

I received a lot of questions on how to use IF function with 3 conditions, so I’ve decided to write an article on this topic. The IF examples described in this article assume that you have a basic...

## How to unmerge cells in Excel

This step-by-step tutorial shows how to unmerge cells in Excel, how to find all merged cells from a worksheet, and how to fill unmerged cells with the original content of the merged cells. Merged cells provide...

# Category - Excel formulas

## Count cells not equal to x or y using COUNTIF

You can count all cells not equal to x or y using a simple COUNTIFS formula. If you only want to count using one condition, then you can also use COUNTIF as an alternative. I’ll explain both in this short tutorial...

## How to use IF function with 3 conditions

I received a lot of questions on how to use IF function with 3 conditions, so I’ve decided to write an article on this topic. The IF examples described in this article assume that you have a basic understanding of...

## How to unmerge cells in Excel

This step-by-step tutorial shows how to unmerge cells in Excel, how to find all merged cells from a worksheet, and how to fill unmerged cells with the original content of the merged cells. Merged cells provide...

## How to use INDEX and MATCH functions in Excel

If you want to take your Excel skills to a new level, you have to learn how to use INDEX And MATCH, combine multiple functions and write complex formulas.

## Fix #NULL!, #REF!, #DIV/0!, #NAME?, #N/A, #NUM, #VALUE, and ##### Excel errors

Learn how to troubleshoot and fix #NULL!, #REF!, #DIV/0!, #NAME?, #N/A, #NUM, #VALUE, and ##### errors in Excel (practical examples included).

## How to find duplicates in Excel using Conditional Formatting

Learn how to find duplicates in Excel. Perform the check in the same column or compare two different sheets, using conditional formatting or formulas.

## Get first day of the month

To get the first day of the month for a given date, you can use two simple approaches: using EOMONTH function or using DAY function.

## Subtotal by item type using SUMIF

If you need to calculate subtotals based on item type (or whatever common criteria), you can easily do so using the SUMIF function.

## Count cells equal to a specific value

Counting cells that equal to a specific value can be achieved using COUNTIF function. If you need to use multiple criteria you can also use COUNTIFS.

## How to change case in Excel to UPPER, lower or Proper

Learn how to change text case to UPPER, lower or Proper format and combine text from different cells to obtain the desired result.