Sum if case-sensitive
In this example, the goal is to sum the quantities in column C by the codes in column E in a case-sensitive manner. The SUMIF function and the SUMIFS function are both good options for counting text values, and...Read more
Learn Excel with clear examples and bite-sized videos.
Featured Functions
RANDARRAY Function
The RANDARRAY function generates an array of random numbers between two values. The size or the array is determined by rows and columns arguments. By default, RANDARRAY returns an array of random numbers between 0 and 1. However, RANDARRAY will generate whole numbers when the...Read more
Recent Articles
The Excel shortcuts you really should know
A curated guide to the most useful Excel shortcuts for Windows and Mac, with explanations, tips, and videos. Covers navigation, selection, data entry, formatting, formulas, and more.Read more
Topics By Category
User Testimonials
I have relied on your website on countless occasions throughout the course of my graduate level finance internship. Compared to a number of unnamed Excel tutorial sites and forums, yours is par-none. It is invariably the only source for consistently accurate and understandable formula functions and syntaxes. I say that as this page has solved an hours-long problem facing me during an all-night work session. Thanks a lot!
Nick
Once again, I find your website the "go-to" source for clean, concise explanations of Excel functionality. A coworker sent an interesting spreadsheet with unique functions to achieve results with non-mathematical data. I had not experienced nor needed this particular sector of Excel software before, and your website made quick work of understanding those new functions and formulas. As an aerospace design engineer, I highly value organized and logically presented information. The cool general layout of the pages and pleasing aesthetics are just a bonus. Keep up the great work!
Z
For sharing your knowledge of Excel. I'm learning a lot and so excited. Your information is nicely explained and I'm able to understand.
Babs
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.
