By SCAggregate in excel used when cells in column contain value error or hidden rows as shown in image. Aggregate formula can be used for any formula max,min,sum,average.
This blog is about working with data by using different tools Excel ,Python, Access Power automate etc .