Web Reference: For example, when you subtotal a horizontal range using option 1, such as AGGREGATE (1, 1, ref1), hiding a column does not affect the aggregate sum value. But, hiding a row in vertical range does affect the aggregate. Example Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. Jun 16, 2024 · This article discusses in detail how to use the AGGREGATE function to extract desired output in Excel with 13 examples. Feb 3, 2025 · In this guide, you’ll learn how to use the AGGREGATE function in Microsoft Excel with real-world examples. We’ll cover how to sum data while ignoring errors, find the maximum value in a filtered list, and count non-empty cells without manual cleanup.
YouTube Excerpt: Learn how to use the powerful
Net Worth Profile Overview
Master Excel S Aggregate Function Net Worth 2026: Salary, Income & Wealth Net Worth & Biography
Estimated Worth: $89M - $132M
Salary & Income Sources
Career Highlights & Achievements
Assets, Properties & Investments
This section covers known assets, real estate holdings, luxury vehicles, and investment portfolios. Data is compiled from public records, financial disclosures, and verified media reports.
Last Updated: April 9, 2026
Net Worth Outlook & Future Earnings
Disclaimer: Disclaimer: Net Worth estimates are based on publicly available data, media reports, and financial analysis. Actual numbers may vary.