Hey guys, need your help again. I'm trying to create a formula that will allow me to use the AverageIfs function to get an average across columns.
Here is my formula but it's not working. =AVERAGE(IF((A$44:A$1000=A8)+(D44:D1000=C1),E44:I55))

Based on the Criteria I'm trying to average E:I. Any thoughts?