I don't see why I would need to use an array over a SUMIFS, can someone shed some light on why the Array is considered better and when I would use it?

Thanks.