For many years, I used the SUBTOTAL function in Microsoft Excel to create easily visible subtotals at the top of my worksheets. However, when I encountered AGGREGATE, this became my go-to function for ...

Unlike SUM, which ignores filters, SUBTOTAL dynamically adjusts to display only visible data. It offers 11 built-in functions, with additional options (101-111) that account for hidden rows. When ...

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...

FORECAST.ETS applies an exponential triple smoothing (ETS) algorithm to create forecasts that can include trend and seasonal ...

Sean Ross is a strategic adviser at 1031x.com, Investopedia contributor, and the founder and manager of Free Lances Ltd. Gordon Scott has been an active investor and technical analyst or 20+ years. He ...

James Chen, CMT is an expert trader, investment adviser, and global market strategist. Erika Rasure is globally-recognized as a leading consumer economics subject matter expert, researcher, and ...

Custom functions enable you to add new functions to Excel by defining those functions in JavaScript as part of an add-in. Users within Excel can access custom functions just as they would any native ...