Excel Formula
--
Newfie
"Newfie809" wrote:
This is a copy of a spreadsheet I have:
A B C D E F
1 Name Grid Years FTE Amount Allowance
2 John A1_E 10 1.00 $000.00 $5.00
3 Jane A1_E 4 .50 $000.00 $5.00
4 Judy A2_E 1 .75 $000.00 $5.00
5 Bill A2_E 1 1.00 $000.00 $5.00
6 Pat A2_E 1 1.00 $000.00 $5.00
and it continues on for 1300 hundred employees.
I would like to create a foumula the would be able to tell me how many
employees there are at say A1, for 1 year and bring back the total FTE for
that group of employees, A2, for 10 years and bring back the total FTE for
that group of employees. Is there anyone that can help me with this formula.
Thank you
--
Newfie
|