Featured Formulas

Count

Running count of occurrence in list

To create a running count for a specific value that appears in a range of cells, you can use the COUNTIF function with an expanding range. In the example shown, the formula in C5 is: =IF(B5=value,COUNTIF($B$5:B5,value),"") where value is the named …Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Math

SUMIFS Function

The Excel SUMIFS function returns the sum of cells that meet multiple conditions, referred to as criteria. To define criteria, SUMIFS supports logical operators (>,<,<>,=) and wildcards (*,?,~), and can be used with cells that contain dates, numbers, and text.Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Thank you so much for this site - really it's head and shoulders above anything else available online.
David
I want to thank you for this website. I have it bookmarked and use it often for my job. Incredible documentation and well presented with examples. An invaluable resource!
Erik
Thank you for a fantastic & ultra useful site! I use it all the time for help with complex Excel functions. And I use your examples when helping my colleagues with their functions...you've made me look like a genius!
Jennifer
More Testimonials

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.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages