How-To Geek on MSN

I ditched SUMIF for SUMIFS in Excel—and my spreadsheets finally work the way I need them to

A simple switch to SUMIFS can make your formulas easier to expand, read, and maintain as your spreadsheets grow.

Excel’s Hidden N Function Lets You Add Comments Inside Formulas

Embed Excel formula comments directly into your math using the N and REPT functions to keep your spreadsheet documentation ...