Thanks to the help from user RasGhul in another post, I was able to create this formula:
=IFNA(INDEX('Revenue Analysis'!$O$2:$O$1201,MATCH($D$4&$D7,INDEX('Revenue Analysis'!$B$2:$B$1201&'Revenue Analysis'!$C$2:$C$1201,),0)),"")
Now I need to a modification of it for another cell in column L that it will total $M$2:$M$1201 + $N$2:$N$1201 + $O$2:$O$1201 then divide that number by 3.
Thanks in advance
=IFNA(INDEX('Revenue Analysis'!$O$2:$O$1201,MATCH($D$4&$D7,INDEX('Revenue Analysis'!$B$2:$B$1201&'Revenue Analysis'!$C$2:$C$1201,),0)),"")
Now I need to a modification of it for another cell in column L that it will total $M$2:$M$1201 + $N$2:$N$1201 + $O$2:$O$1201 then divide that number by 3.
Thanks in advance