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

# COUNTIF

## Highlight Values Found Multiple Times

| February 27, 2024 |

Today, we’ll highlight recurring values within a dataset in order to answer a recent question. I was asked the following “I’m trying to get it to recognize if a specific letter, like X, is in a column at least three times. What could the formula look like?” And I’ll answer that question in this post.…

## Count and Sum Negative Numbers

| November 28, 2023 |

Welcome to our tutorial on how to count and sum negative numbers in Excel! We will cover three exercises where we will learn how to utilize COUNTIF, SUMIF, and conditional formatting to count, sum, and identify negative transactions. By the end, you will have multiple techniques to operate on negative numbers in Excel. Let’s jump…

## Count Text in Excel – Characters, Words, & Cells With Text

| September 26, 2023 |

Need to know the word count of a spreadsheet you’re working on, or maybe the number of cells that contain text? Even though there’s no built-in counting tool, you can still count text in Excel using a few simple formulas! Count the Number of Characters in a Cell or Range Using the LEN function is…

## Excel SUMIF Function

| April 18, 2023 |

In this post, we’re going to dive into one of the most useful techniques in Excel … conditional summing. We will discuss the SUMIF function, what it does, what its arguments are, and how it compares to SUMIFS, VLOOKUP, and COUNTIF. Video What the SUMIF Function Does So, what is SUMIF in Excel? SUMIF is…