# Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

# COUNTIFS

## Excel How to Count Cells between dates

| October 17, 2023 |

This tutorial demonstrates how to count the number of date cells that fall between two specific dates using COUNTIFS. We will start with a simple exercise using a single condition and gradually progress to more complex exercises involving multiple conditions and comparison operators. By the end of this tutorial, you will be able to perform…

## Convert Dates into Ages

| August 1, 2023 |

If you need to calculate the age in years based on a list of birth dates in Excel, fear not! In this short tutorial, we’ll cover a few functions that will help, as well as a method to count the number of rows in each age group. Specifically, we’ll explore the YEARFRAC, TRUNC, DATEDIF, and…

## Excel How To Compare Two Columns (3 ways)

| July 18, 2023 |

Using Microsoft Excel to compare two columns is a great way to look for discrepancies or similarities between two different sets of data. This post provides 3 different ways to accomplish this so that you can use the one that is most appropriate for your data and workbook. Video Step-by-step guide Let’s work through each…

## How to Count Cells That Contain Specific Text

| October 25, 2022 |

Have you ever wanted to see how many times a certain text string pops up in a set of data? While you can use Ctrl + F to find values, you may need a search feature that’s more discerning and responsive.  Luckily, there are several (much faster!) ways you can count cells that contain specific…

## How to Highlight Duplicates in Excel

| July 26, 2022 |

A duplicate value is a value that shows up more than once in a spreadsheet. These pop up all the time when working with datasets, and they can be tedious to sort through if you don’t know the quick ways to find them. Learn how to highlight duplicates in Excel to make the process take…

## How to Use Excel for Finance: Balancing Your Personal Budget

| June 7, 2022 |

Want to know how to use Excel for finance & budgeting? Here’s how to create a customizable budget that accurately tracks income and expenses.

## Excel Formulas Cheat Sheet for Beginners

| May 17, 2022 |

Excel is one of the most powerful accounting software tools out there, and most of that power comes from the ability to use Excel formulas to automate your work. When you’re first learning how to use them, it’s easy to get a little overwhelmed – luckily, this Excel formulas cheat sheet is here to help…

## Count Between Dates

| March 4, 2020 |

Let’s say you measure something with a duration that can span multiple days. For example, a hotel guest can check in for multiple days, a patient can be in a hospital for multiple days, a widget can be in a specific manufacturing stage for multiple days, a book can be checked out for multiple days,…

## Sum a Column Based on Values in Another

| May 22, 2019 |

In this post, we’ll learn how to add up a column of numbers based on the values in another column. For example, we are trying to analyze product sales based on average customer rating. That is, customers rate our products on a scale of 1 to 10, and so each product has an average rating…