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

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