Quick, clean, and to the point. Join more than 100,000 people who get weekly tips from us.
If you want to take an action when a cell value is greater than a certain value, you can use the IF function to test a value and return one value if the test is true, and another if the test is false. In the example shown, we are using this formula in cell F6. = IF ( E6 > 30 , "Yes...Read more
If you need to add up (sum) up race time splits that are some combination of hours, minutes, and seconds, you can simply use the SUM function. The formula in cell H5 is: = SUM ( C5:G5 ) However, you must take care to enter times with the right syntax and use a suitable time format to display...Read more
To rank items in a list using one or more criteria, you can use the COUNTIFS function. In the example shown, the formula in E5 is: = COUNTIFS ( groups , C5 , scores , ">" & D5 ) + 1 where "groups" is the named range C5:C14, and "scores" is the named range D5:D14. The result is a...Read more
If you want to test a cell and take some action if the cell is not blank (not empty), you can use a simple formula based on the IF function. In the example shown, we have a simple task list with a date complete in column D. In column E, we have a formula that checks cells in column D to see if they...Read more
To count values that are out of tolerance in a set of data, you can use a formula based on the SUMPRODUCT and ABS functions. In the example shown, the formula in F6 is: = SUMPRODUCT ( -- ( ABS ( data - target ) > tolerance )) where "data" is the named range B5:B14, "target" is the named range F4...Read more
A mixed reference is part relative, and part absolute. Mixed references are useful when you want only part of a cell reference to change when you copy a formula.
In this video, we look at how to build a chart that automatically includes new data, and dynamically highlights the top and bottom values. This is an easy way to create an interactive chart...
Puzzled by Pivot Table layouts? Wonder what the differences and tradeoffs are in each layout? This video is for you!
The IF function is very versatile. You can use it whenever you need to test a condition and take an action based on the result. You can even combine multiple IF statements to check multiple...
In this video, we show how to plot American generations in a floating horizontal bar chart. This seems like a simple problem, but it requires a formula, clever formatting, and a special...
The double negative coerces TRUE or FALSE values to their numeric equivalents, 1 and 0. This is a useful technique in many advanced formulas that work with cell ranges.
Excel contains over 450 functions. Where should you start? This guide is a walkthrough of over 100 important functions in Excel. Click function names for details and linked examples.
Criteria are a key concept in Excel, but building useful criteria for text, numbers, dates, times, etc. is hard because it requires a good understanding of how Excel handles data. This guide will help you build formulas that work the first time with over 50 examples.
Every once in a while, you might find Excel behaving in a bizarre or unexpected way. One example is when you accidentally trigger the scroll lock feature. Another example is when one or more formulas suddenly stops working. Instead of a result, you see only a formula. What?
Excel Tables have a boring (and confusingly generic) name, but they are packed with useful features. This article is a summary of the things you should know about Excel Tables.
Thank you for the amazing work. Keep it up. Adding value to everyone's life... -Kam
I would like to thank you for the great website. As you mentioned in it's title, it is truly "Quick, clean and to the point". It looks impossible to delivery information shorter and more informative. -Nikita
This site is perfect for me as a moderate Excel user who sometimes needs a formula that I cannot figure out on my own. It's clean, easy to use, comprehensive and doesn't have distracting material like many other Excel help sites. - Susan