Updating Existing Formula: Counting Metrics

Aimee Peyton-Greene

Hello! I am working on a formula that I had once before that is not working when I transfer it to a new sheet and update the names of the rows that I wanted to add.

Prior Formula: =SUMIFS(CHILDREN(), CHILDREN([Recruiter Name]@row), AND(@cell <> "Full Time >0.5",

@cell + ROUNDDOWN(SUMIF(CHILDREN([Recruiter Name]@row), "Part Time/PRN", CHILDREN()) * 0.5)

The formula needed to count 1 for the Full Time hires, .5 for the part time/prn hires (rounded down), transfers, subtract for each ft rescinded and .5 rounded down for each of the PT/PRN Rescinded, and subtract for the 90 Day Terms.

An example: Recruiter 17 had:

17 FT Hires

24 PT/PRN Hires (counts for 12)

11 Transfers

but also had

4 ft rescind

5 pt/prn rescind (counts for 2)

0 prior month rescind

and 1 90 day term

Desired outcome would be for the parent to measure the children and output the correct number with the specified .5 round downs on the appropriate spaces.

Mark Cronk

Hi Aimee,

Try:

=SUM(CHILDREN())-ROUNDUP(SUMIFS(Children(), CHILDREN([Recruiter Name]), @cell ="Full Time >0.5")*0.5)-ROUNDUP(SUMIFS(Children(), CHILDREN([Recruiter Name]), @cell ="Part Time/PRN")*0.5)-ROUNDUP(SUMIFS(Children(), CHILDREN([Recruiter Name]), @cell ="PT/PRN Rescind")*0.5)

Work? Help?

Mark