Get more flexibility and speed from SUMIF and COUNTIF functions, whether you are new to them or use them already.
Quickly organize your data into tables for faster updating, while keeping references, totals and formats updated automatically.
About circular reference errors, circular reference warnings, how to find and correct them... and when to embrace circular references!
Insert today's date or time, adjust formatting, and see how to update the date and time automatically.
Use absolute and relative references to control whether your formulas stay the same or update when copied to other cells.
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.