I am trying to do a table calculation which will average one column, based on a criteria in a row. In the below table, the value I’d be looking for in the 4th column would be $162.5 (average of 150 & 175)
| User ID | DMA | Quote Value | Average Value |
|---|---|---|---|
| 12345 | New York | $150 | =Averageif(DMA column, DMA, Quote value) |
| 188737 | Washington, DC | $125 | |
| 17772 | New York | $175 |