AVERAGEIFS function


Excel » Functions » Statistical » AVERAGEIFS function »

How to use the AVERAGEIFS function

The AVERAGEIFS function returns the average of cell values that evaluates to TRUE for multiple criteria. Formula in cell F6: =AVERAGEIFS(D3:D8,B3:B8,F3,C3:C8,G3) […]

  • Weekly Blog EMAIL

    Get a FREE PDF book!

  • Welcome! I am Oscar and here to help you out.

    Feel free to comment and ask Excel questions.

    Make sure you subscribe to my newsletter so you don't miss new blog articles.