Sum if not blank
In this example, the goal is to sum the Amounts in C5:C16 when the Lead in D5:D16 is not blank (i.e., not empty). A good way to solve this problem is to use the SUMIFS function. However, you can also use the ...Read more
Learn Excel with clear examples and bite-sized videos.
Featured Functions
Recent Articles
Native checkboxes in Excel
If you've ever tried to create a to-do list, survey, or any kind of checklist in Excel, you've probably wished for a simple checkbox feature. Well, your wish has finally come true. Microsoft has finally introduced a native checkbox feature in Excel. It's easy to use
...Read more
Topics By Category
User Testimonials
Just wanted to say God bless you people! You've done an amazing service to a lot of people by creating this website. I can't speak for everyone but you have definitely helped me get things done very quickly more times I can count.
Istvan
I just wanted to say thank you for your quick and concise explanations of excel topics. If I have a question on a topic or function and google it, I always go to your site for the answer.
Clint
I just wanted to say thanks for the great site. I'm impressed by the level of quality in both the clear layout and useful examples. It's a testament to the effort that you two must have put into it. I greatly appreciate it!
Simon
Get Training
We offer free resources and paid training.
Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.
