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.


Highlight Values Found Multiple Times

By Jeff Lenning | 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.…

Read More

Count and Sum Negative Numbers

By Jeff Lenning | 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…

Read More
Child sitting in front of a computer screen learning how to count text in Excel

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

By Excel University | 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…

Read More

Excel SUMIF Function

By Jeff Lenning | 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…

Read More
Woman sitting at a desk with a calculator after learning how to count cells containing specific text in Excel

How to Count Cells That Contain Specific Text

By Excel University | 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…

Read More