Tracking activities
Hi,
I have an excel table with following fields and sample data
DOCNAME NUMPAGES PERSON %COMPLETE
Doc1 20 A 50
Doc2 52 B 30
Doc3 26 D 60
Doc4 60 A/C/D 80
Doc5 15 B/C 100
...etc..
I need to make a summary sheet containing how much each person has
completed, like:
PERSON %COMPLETED
A ?? <-- X
B ??
C ??
D ??
The way to compute X would be:
Sum (NUMPAGES * %COMPLETED * Factor) for all rows where A is the
person. Factor is calculated as:
1, if 1 person is doing it
1/2, if 2 person is doing it
1/3, if 3 person is doing it
I know about implementing multiple conditions in SUMPRODUCT, but
unable to understand how to implement this.
Any clues would be appreciated!
Regards,
~Animesh
|