Average ifs calculatoin

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  

New York



0 replies

Be the first to reply!