Spreadsheet: 849670d1700082164-averageifs-to-return-dynamically-across-the-columns-and-down-the-rows-averageifs-to-return-dynamic-array
Sheet: Sheet1

Div | Mstr Pln Comm | Product Type | Plan | Affix | Sub | Category | Amount |  |  |  |  |  | P30 | P30 | P30
OS | HMW | P30 | G | CR | 40010 | General | 1849.6 |  |  |  |  |  | OS | OS | OS
OS | HMW | P30 | G | CR | 40025 | General | 1626 |  |  |  | Categories | Cost Code | HMW | JKR | KWT
OS | HMW | P30 | G | FH | 40010 | General | 1849.6 |  |  |  | General | 40010 | 2115.1 | 2565.78125 | 2396.46875
OS | HMW | P30 | G | FH | 40025 | General | 1317 |  |  |  | General | 40020
OS | HMW | P30 | G | GE | 40010 | General | 1849.6 |  |  |  | General | 40025 | 1497.9375 | 1525 | 444
OS | HMW | P30 | G | GE | 40025 | General | 1087
OS | HMW | P30 | G | TN | 40010 | General | 1849.6 |  |  |  |  | Desired Result to be in Dynamic Array
OS | HMW | P30 | G | TN | 40025 | General | 1205
OS | HMW | P30 | K | CR | 40010 | General | 2090.8 |  |  |  |  | Assume this is [NAME]
OS | HMW | P30 | K | CR | 40025 | General | 1458
OS | HMW | P30 | K | FH | 40010 | General | 2090.8
OS | HMW | P30 | K | FH | 40025 | General | 1602 |  |  |  |  |  |  | #N/A | #N/A
OS | HMW | P30 | K | GE | 40010 | General | 2090.8 |  |  |  |  |  | #N/A | #N/A | #N/A
OS | HMW | P30 | K | GE | 40025 | General | 1194 |  |  |  |  |  | #N/A | #N/A | #N/A
OS | HMW | P30 | K | TN | 40010 | General | 2090.8
OS | HMW | P30 | K | TN | 40025 | General | 1349 |  | MAP($L$4:$L$6,$M$4:$M$6,$N$1:$P$1,$N$2:$P$2,$N$3:$P$3,
OS | HMW | P30 | D | CR | 40010 | General | 2168.2 |  | LAMBDA(x,y,i,j,k,
OS | HMW | P30 | D | CR | 40025 | General | 1721 |  | AVERAGEIFS($H$2:$H$81, $[NAME], x, $[NAME], y, $C$2:$C$81, i, $A$2:$A$81, j, $B$2:$B$81, k)))
OS | HMW | P30 | D | FH | 40010 | General | 2168.2
OS | HMW | P30 | D | FH | 40025 | General | 1689
OS | HMW | P30 | D | GE | 40010 | General | 2168.2
OS | HMW | P30 | D | GE | 40025 | General | 1474
OS | HMW | P30 | D | TN | 40010 | General | 2168.2
OS | HMW | P30 | D | TN | 40025 | General | 1676
OS | HMW | P30 | L | CR | 40010 | General | 2351.8
OS | HMW | P30 | L | CR | 40025 | General | 1703
OS | HMW | P30 | L | FH | 40010 | General | 2351.8
OS | HMW | P30 | L | FH | 40025 | General | 1774
OS | HMW | P30 | L | GE | 40010 | General | 2351.8
OS | HMW | P30 | L | GE | 40025 | General | 1483
OS | HMW | P30 | L | TN | 40010 | General | 2351.8
OS | HMW | P30 | L | TN | 40025 | General | 1609
OS | JKR | P30 | D | CR | 40010 | General | 2457.5
OS | JKR | P30 | D | CR | 40025 | General | 1525
OS | JKR | P30 | D | GE | 40010 | General | 2455.4
OS | JKR | P30 | D | GE | 40025 | General | 1525
OS | JKR | P30 | D | FH | 40010 | General | 2456.45
OS | JKR | P30 | D | FH | 40025 | General | 1525
OS | JKR | P30 | D | TN | 40010 | General | 2461.7
OS | JKR | P30 | D | TN | 40025 | General | 1525
OS | JKR | P30 | L | CR | 40010 | General | 2671.7
OS | JKR | P30 | L | CR | 40025 | General | 1525
OS | JKR | P30 | L | GE | 40010 | General | 2679.05
OS | JKR | P30 | L | GE | 40025 | General | 1525
OS | JKR | P30 | L | FH | 40010 | General | 2669.6
OS | JKR | P30 | L | FH | 40025 | General | 1525
OS | JKR | P30 | L | TN | 40010 | General | 2674.85
OS | JKR | P30 | L | TN | 40025 | General | 1525
OS | KWT | P30 | G | CR | 40010 | General | 2080.55
OS | KWT | P30 | G | CR | 40025 | General | 444
OS | KWT | P30 | G | FH | 40010 | General | 2085.8
OS | KWT | P30 | G | FH | 40025 | General | 444
OS | KWT | P30 | G | GE | 40010 | General | 2095.25
OS | KWT | P30 | G | GE | 40025 | General | 444
OS | KWT | P30 | G | TN | 40010 | General | 2083.7
OS | KWT | P30 | G | TN | 40025 | General | 444
OS | KWT | P30 | K | CR | 40010 | General | 2370.35
OS | KWT | P30 | K | CR | 40025 | General | 444
OS | KWT | P30 | K | FH | 40010 | General | 2365.1
OS | KWT | P30 | K | FH | 40025 | General | 444
OS | KWT | P30 | K | GE | 40010 | General | 2371.4
OS | KWT | P30 | K | GE | 40025 | General | 444
OS | KWT | P30 | K | TN | 40010 | General | 2365.1
OS | KWT | P30 | K | TN | 40025 | General | 444
OS | KWT | P30 | D | CR | 40010 | General | 2457.5
OS | KWT | P30 | D | CR | 40025 | General | 444
OS | KWT | P30 | D | FH | 40010 | General | 2456.45
OS | KWT | P30 | D | FH | 40025 | General | 444
OS | KWT | P30 | D | GE | 40010 | General | 2455.4
OS | KWT | P30 | D | GE | 40025 | General | 444
OS | KWT | P30 | D | TN | 40010 | General | 2461.7
OS | KWT | P30 | D | TN | 40025 | General | 444
OS | KWT | P30 | L | CR | 40010 | General | 2671.7
OS | KWT | P30 | L | CR | 40025 | General | 444
OS | KWT | P30 | L | FH | 40010 | General | 2669.6
OS | KWT | P30 | L | FH | 40025 | General | 444
OS | KWT | P30 | L | GE | 40010 | General | 2679.05
OS | KWT | P30 | L | GE | 40025 | General | 444
OS | KWT | P30 | L | TN | 40010 | General | 2674.85
OS | KWT | P30 | L | TN | 40025 | General | 444