Section outline

  • Exercise: using functions requiring criteria
    • In the Excel file wich follows you can find data about the urban population in Italy in various ages.
    • Urban population in various ages File
    • Try to reproduce the following worksheets by using the data contained in the previous file. A good knowledge of the syntax of functions like COUNTIF, SUMIF, COUNTIFS, SUMIFS, ..., is required.
    • Analysis n.1 of urban population File
    • Analysis n.2 of urban population File