Calculate ATNE, the average total number of employees, from entered monthly employee counts, total employee sum, or number of months.

Use the sum of monthly employee headcounts and the number of months included. Count each month equally.

Add the headcount for each included month; this is not a count of unique employees.

ATNE Formula

The following formula and example show how to calculate ATNE.

ATNE = SE / M

Variables:

  • ATNE is the ATNE (average total number of employees)
  • SE is the total sum of each months employee count 
  • M is the total number of months 

To calculate the average total number of employees, sum the total of each months employee count, then divide by the number of months.

How to Calculate ATNE?

Select Average employees — from totals and follow these steps. Alternatively, choose Average employees — by month, enter the relevant month-end headcounts, and select Calculate. Blank months are excluded; a zero count is included.

  1. First, determine the total sum of each months employee count. 
  2. Next, determine the total number of months. 
  3. Next, gather the formula from above = ATNE = SE / M.
  4. Finally, calculate the ATNE.
  5. After inserting the variables and calculating the result, check your answer with the calculator above.

Example Problem : 

Use the following variables as an example problem to test your knowledge.

total sum of each months employee count = 500

total number of months = 6

ATNE = SE / M = 500 / 6 ≈ 83.3333 employees.