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
TEXTJOIN Function
The TEXTJOIN function concatenates multiple values together with or without a delimiter. TEXTJOIN can concatenate values provided as cell references, ranges, or constants, and can optionally ignore empty cells.
The TEXTJOIN function...Read more
Topics By Category
User Testimonials
You saved my butt. I was using VLOOKUP and kept getting NA error, due to formatting i guess. after reading tons of pages you have the answer =VLOOKUP(id&"",planets,2,0)
Charles
I wanted to thank you for your site. I used it heavily when I started working at internships in college and I am now a PhD student who still finds her way back on the site for help. I really appreciate how straightforward and helpful your content is.
Melissa
What a nice job. Your web site is my "go-to" place for any help with Excel!
Vimal
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.
