Question

Average ifs calculatoin

  • 21 July 2021
  • 0 replies
  • 22 views

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  

 


0 replies

Be the first to reply!

Reply