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 |