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.


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
Lookup Range by Jeff Lenning

Return the Sum of Two or More Columns with VLOOKUP

By Jeff Lenning | October 29, 2015 |

If you have ever wished that the VLOOKUP function could return the sum of two or more related columns, this trick will get you there. Objective Before we get into the details, let’s be clear about our objective. We have some transactions that were exported from our accounting system as shown below. We would like…

Read More

Income Tax Formula

By Jeff Lenning | December 31, 2014 |

In this post, we’ll examine a couple of ideas for computing income tax in Excel using tax tables. Specifically, we’ll use VLOOKUP with a helper column, we’ll remove the helper column with SUMPRODUCT, and then we’ll use data validation and the INDIRECT function to make it easy to pick the desired tax table, such as single or married…

Read More