title: Excel - Averege value in column when cells contains certain text but average without zeros
body: <p>I'm trying to get average up the row of number when a cell in the same row contains text "mobile" with this formula =AVERAGEIF(A:A,"*mobile",B:B) but I don't get good value because zeros in Column B.</p>
  
  <p>[Column A - Website]<br>
  Blic - computer<br> 
  Blic - mobile<br>
  b92 - computer<br>
  b92 - mobile<br>
  politika - computer<br> 
  politika - mobile<br></p>
  
  <p>[Column B - Cost]<br>
  $5.00<br>
  0<br>
  0<br>
  $13.00<br>
  $20.00<br>
  $17.00<br></p>
  
  <p>Average - computer  $8.33<br>
  Average - mobile    $10.00<br>
  Average - total $9.17</p>
  
  <p>How to exclude zeros?</p>
  
  <p>Thanks,</p>