How to count cells not equal to x or y using COUNTIFS
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 [...]
How to get first day of the month in Excel
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.
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 [...]
How to count cells between two dates using COUNTIFS
You can use the COUNTIFS function to count the number cells between two dates of an Excel file. Example file included.
How to clear formatting in Excel [multiple options + keyboard shortcut]
Adding colors and number formatting can improve the readability of your Excel reports, but sometimes you will want to remove all the formatting and start over. This is why it [...]
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 separate First and Last name in Excel [easy methods]
It's very common to get a database that contains a column with full names, separated either by space, comma, or a mix of symbols. That is why it's important to [...]
Count cells that contain odd numbers with SUMPRODUCT
In this article, I'll explain how to count cells that contain odd numbers in Excel. This example uses two functions: SUMPRODUCT and MOD. Before we begin, I suggest that you [...]
Count cells not between two numbers
If you are looking to count cells not between two numbers in Excel using COUNTIFS, then you are in for a disappointment. That's because COUNTIFS uses the AND logic when [...]
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 [...]
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.
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.
Excel is a very complex application, and understanding it on your own may prove difficult and time-consuming. I have created to help you better understand each function and provide useful examples for different tasks. If you can’t find the answer to your question in one of the published articles, please leave a comment or send me an email, and I will do my best to help you out.

Affiliate Disclosure: When you purchase a product through a link on our website, I may earn an affiliate commission. There are no additional costs to you.
Copyright © 2017-2021