See Mr Excel and excelisfun try and create Horizontal Subtotals for a data set. See the IF, SUM and SUMIF functions as they try to solve this very difficult problem. Also see Conditional Formatting for non-contguous cell ranges using a TRUE FALSE logical formula with the NOT symbols.
Questions about Mr Excel & excelisfun Trick #5: Horizontal Subtotals
Want more info about Mr Excel & excelisfun Trick #5: Horizontal Subtotals?
Get free advice from education experts and Noodle community members.