How To: Create horizontal subtotals for a data set in MS Excel

Create horizontal subtotals for a data set in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 5th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create horizontal subtotals for a data set using the IF, SUM and SUMIF functions. Also see conditional formatting for non-contiguous cell ranges using a TRUE/FALSE logical formula with the NOT symbols.

Daily Tips For Your Phone

Get the Gadget Hacks newsletter for new tips every day.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest