Scribd Logo
Upload

Welcome to Scribd!

  • 7 views

    How To Use Averageifs Formula

    Uploaded by

    Kalpita Kotkar
    The document discusses how to use the Averageifs formula in Excel to calculate average values from a data set that meets multiple criteria. It provides an example data set with columns for property Type, Price, Town, and Rooms. The Averageifs formula can be used to find the average price for a specific property Type in a certain Town with a minimum number of Rooms.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    How To Use Averageifs Formula

    Uploaded by

    Kalpita Kotkar
    7 views2 pages
    The document discusses how to use the Averageifs formula in Excel to calculate average values from a data set that meets multiple criteria. It provides an example data set with columns for property Type, Price, Town, and Rooms. The Averageifs formula can be used to find the average price for a specific property Type in a certain Town with a minimum number of Rooms.

    Original Title

    How to use Averageifs formula

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses how to use the Averageifs formula in Excel to calculate average values from a data set that meets multiple criteria. It provides an example data set with columns for property Type, Price, Town, and Rooms. The Averageifs formula can be used to find the average price for a specific property Type in a certain Town with a minimum number of Rooms.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    7 views2 pages

    How To Use Averageifs Formula

    Uploaded by

    Kalpita Kotkar
    The document discusses how to use the Averageifs formula in Excel to calculate average values from a data set that meets multiple criteria. It provides an example data set with columns for property Type, Price, Town, and Rooms. The Averageifs formula can be used to find the average price for a specific property Type in a certain Town with a minimum number of Rooms.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 2

    How to use Averageifs formula in excel

    Type Price Town Rooms


    Flat 230000 Delhi 3
    Flat 197000 Delhi 2
    Bunglow 345678 Delhi 4
    Bunglow 321900 Mumbai 2
    Duplex 450000 Mumbai 5
    Duplex 395000 Mumbai 4
    Flat 330000 Delhi 3
    Duplex 285000 Delhi 2
    Bunglow 987654 Delhi 3
    Duplex 321900 Mumbai 2
    Flat 850000 Mumbai 5
    Bunglow 795000 Mumbai 4
    Type Town Rooms
    Duplex Mumbai 5

    Price
    450000

    You might also like