I am trying to take a list of all employees that includes their info like department, name, and age and then create a age range (like 16-24, 25-34, etc...) so I can then count how many employees fall under each age range.
I have tried two ways and neither work.
FIRST ATTEMPT:
-The first and i think easiest is to have a helper sheet that contains my age range i want to use. That way on my main sheet i can use a vlookup formula to pull in the range result.
-here is my main sheet with the helper column called 'age group'. and the formula being used:
=VLOOKUP(Age@row, {HR DASH - HEADCOUNT (METRICS) Range 2}, 2, true
-and in that formula, here is the cross reference being used with my age range
SECOND ATTEMPT:
The other idea I had, was to pull in counts on a helper sheet. But the formula keeps coming up with 0:
same main sheet as shown above
here is the helper/metrics sheet and the formula being used:
=COUNTIFS({Hr Age Range}, AND(@cell >= 16, @cell <= 24), {Hr Headcount by line of business}, [Line of Business]@row)
here are the cross references: