Hello, can you please help me? I have raw data and I need the count of population sorted by age group and gender. For example, how many between the age 1-5 male or female. How do I do it?
Hello To count the population sorted by age group (1-5) and gender (Male/Female) from your raw data you need to use Formula and Pivot Table. First, Create the Age Group: Suppose you have columns named Age and Gender. Now, create a new column in your spreadsheet to categorize each individual's age into specific age groups. For example, you could define age groups as 1-5, 6-10, etc. Insert a Age Group next to the Age column. Use an IF formula to categorize the ages. For ages 1-5: =IF(AND(Age>=1, Age PivotTable. 3. In the PivotTable Fields, drag: Age Group to the Rows area. Gender to the Columns area. Any column with consistent values (like ID or Name) to the Values area (this will automatically count the entries). Regards ExcelDemy
Hello, can you please help me?
I have raw data and I need the count of population sorted by age group and gender. For example, how many between the age 1-5 male or female. How do I do it?
Hello
To count the population sorted by age group (1-5) and gender (Male/Female) from your raw data you need to use Formula and Pivot Table.
First, Create the Age Group:
Suppose you have columns named Age and Gender.
Now, create a new column in your spreadsheet to categorize each individual's age into specific age groups.
For example, you could define age groups as 1-5, 6-10, etc.
Insert a Age Group next to the Age column.
Use an IF formula to categorize the ages.
For ages 1-5: =IF(AND(Age>=1, Age PivotTable.
3. In the PivotTable Fields, drag:
Age Group to the Rows area.
Gender to the Columns area.
Any column with consistent values (like ID or Name) to the Values area (this will automatically count the entries).
Regards
ExcelDemy