• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Quarterly headcount

richlyn

New Member
Hi People,

this issue i am facing is counting average headcount in a quarter.
the long way is i have monthly headcount which i average
for the monthly HC (headcount) of march i use countif

Countif(join Date column, <April 1) minus Countif (attrite date column, <April 1) ---sum all heads joined before april 1 and minus all attrite before april 1.

then average the monthly HC of each month to get the quarterly HC.

How can i do the quarterly HC directly using formulas.
 
Here is the sample file.
in the "HC & Attrition BU Wise" sheet i am attempting to do Calculate F7 independently
 

Attachments

  • Sample.xlsb
    134.4 KB · Views: 10
Back
Top