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
Seeded Random Number Generator in Excel
Excel's random functions like RAND and RANDARRAY recalculate every time you edit your worksheet, making it impossible to maintain stable random results. This article shows you how to build a seeded random number generator using Excel's LAMBDA function, allowing you to generate reproducible...Read more
Topics By Category
User Testimonials
I use exceljet every week at my workplace. I love your content, it helps me a lot in getting things done quickly. As your tag line says Quick, Clean and to the point, your explanation is exactly what it says. Thanks a lot :)
Rahul
Wanted to let you know how helpfully your products have been. The weekly email is great. The one today about tables and vlookup has me working on changing several spreadsheets I use every day to a table format with vlookup & match. I regularly go to the web site when I am looking for a solution while working in excel.
George
About 2-3 months ago, I subscribed to Exceljet after doing an 'Intermediate' Excel course. I have really enjoyed the periodic emails from you since then, which have been incredibly helpful and useful.
Michael
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.
