Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals. Learn how to ...
AGGREGATE was built to handle messy data from the start.
How-To Geek on MSN
Master Excel's Total Row for better data insights
Excel's Total Row uses smart SUBTOTAL logic to ignore hidden data, adapt to filters, flag text errors, and measure performance volatility.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results