R
Roy Bunch
Ok guys, what I am looking for a certain formula.. here is the sample o
the spreadsheat
.........a..................b.................c............d..........
1 John Doe.....10/06/04....10/08/04
2 Frank Doe....9/9/04........9/10/04.....9/12/04
3 Jim Doe........10/1/04..................................
4
5
Basically what I want it to do is count how many "people" I have in th
first colum come up with a percentage complete. I.E if based on th
current example I have 3 people and I have done 6 of 9 tasks and I a
66% complete.
I want it flexible enough so if I throw in another name on line 4 the
it automatically calculates a new percentage.. I.E I would be 6 of 1
tasks done or 50% complete unless I fill in more data for colums B,C
and D.
Anyone suggest a formula for me? Thanks in advance
the spreadsheat
.........a..................b.................c............d..........
1 John Doe.....10/06/04....10/08/04
2 Frank Doe....9/9/04........9/10/04.....9/12/04
3 Jim Doe........10/1/04..................................
4
5
Basically what I want it to do is count how many "people" I have in th
first colum come up with a percentage complete. I.E if based on th
current example I have 3 people and I have done 6 of 9 tasks and I a
66% complete.
I want it flexible enough so if I throw in another name on line 4 the
it automatically calculates a new percentage.. I.E I would be 6 of 1
tasks done or 50% complete unless I fill in more data for colums B,C
and D.
Anyone suggest a formula for me? Thanks in advance