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 ...

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 ...

Julia Kagan is a financial/consumer journalist and former senior editor, personal finance, of Investopedia. Vikki Velasquez is a researcher and writer who has managed, coordinated, and directed ...

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 ...