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

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

Optional settings

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 monthโ€™s employee count 
  • M is the total number of months 

To calculate the average total number of employees, sum the total of each monthโ€™s 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 monthโ€™s 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 monthโ€™s employee count = 500

total number of months = 6

ATNE = SE / M = 500 / 6 โ‰ˆ 83.3333 employees.