Get more flexibility and speed from SUMIF and COUNTIF functions, whether you are new to them or use them already.
Save time with data tables
Quickly organize your data into tables for faster updating, while keeping references, totals and formats updated automatically.
How to fix circular references
About circular reference errors, circular reference warnings, how to find and correct them... and when to embrace circular references!
Insert the current date or time
Insert today's date or time, adjust formatting, and see how to update the date and time automatically.
Absolute and relative references
Use absolute and relative references to control whether your formulas stay the same or update when copied to other cells.
Save time with subtotal formulas
Subtotals save time, reduce errors and provide confidence. Learn how to use subtotal formulas to speed up your spreadsheets and cut down editing time. Know your way around subtotals already? Check out this tip to see if you're getting the most out of them.