How to calculate Age and summary data base on age with male or female in Excel with Example Download and video

In this tutorial we show two different ways to calculate age in Excel and then how to summary data base on different age category with male and female as one table with different Excel formula. Below are main Excel formulas use in this example.

Userful links:

⚡ How to Download and Install Khmer Unicode for Windows and Mac OSX (apple)
⚡ Free ebook Download - free PDF download
⚡ Learn Excel Formulas with Video and Example Download

YEAR formula in Excel

YEAR returns integer number of year from date.
FORMULA:

=YEAR(serial_number)

◾ serial_number: Required, the date you want to get year from.

YEARFRAC formula in Excel

YEARFRAC returns number of whole year between two date.
FORMULA:

=YEARFRAC(start_date, end_date, [basis])

◾ start_date: Required, a date represent start date.
◾ end_date: required, a date represent end date.
◾ basis: optional, the type of count to be use.
To summary data for both male and female into a table we can use some formulas belows

COUNTIF formula in Excel

COUNTIF is used to count number of cells that meet criteria.
FORMULA:

=COUNTIF(range,criteria)

◾ range: Required, set of cells or numbers of cells to be count.
◾ criteria: Required, condition to be count.

COUNTIFS formula in Excel

COUNTIFS is used to count number of cells base on multiple condition.
FORMULA:

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

◾ criteria_range1: Required, first range to evaluate with first criteria. ◾ criteria1: Required, first condition to evaluate. ◾ criteria_range2,criteria2,... are optional, it is use if you want to have more conditions.

The rest of formulas and how to use all above formulas, check in video demo below for detail information

Watch How to calculate Age and summary data base on age with male or female in Excel speak Khmer

DOWNLOAD EXAMPLE EXCEL FILE, Source 1 or 2

Userful links:

⚡ How to Download and Install Khmer Unicode for Windows and Mac OSX (apple)
⚡ Free ebook Download - free PDF download
⚡ Learn Excel Formulas with Video and Example Download