Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...

Investopedia contributors come from a range of backgrounds, and over 25 years there have been thousands of expert writers and editors who have contributed. Amy is an ACA and the CEO and founder of ...

Suzanne is a content marketer, writer, and fact-checker. She holds a Bachelor of Science in Finance degree from Bridgewater State University and helps develop content strategies. Learn about our ...

Many of us fell in love with Excel as we delved into its deep and sophisticated formula features. Because there are multiple ways to get results, you can decide which method works best for you. For ...