If statements and task occurence count from a drop down list

[mreljic]

Hello,

I have a data source that is basically a drop down list of name. In another worksheet (the same spreadsheet), i have to create a formula that will capture if task occurances were completed. For example, from the data source below Alan has completed his task "Completed-On Time", once. Complete- Late is zero and Incomplete is Zero. Please let me know if you have any suggestions on how i can create a formula that would automatically count Alan's tasks when his name is selected from the drop down list. Thank you very much! Miro
PS Please see the attached Excel spreadshet.

Data Source
Person Task
Alan COMPLETE - ON TIME
Kaushal COMPLETE - LATE
Kaushal COMPLETE - ON TIME
Kaushal INCOMPLETE
Nicolas COMPLETE - LATE
Nicolas COMPLETE - LATE
Nicolas INCOMPLETE

The Result table:
Alan
Status Month
COMPLETE - ON TIME 1 If Name is equal to Alan, and if it is equal to Complete- On Time, count this task occurance otherwise don’t count
COMPLETE - LATE 0 If Name is equal to Alan, and if it is equal to Complete- Late, count this task occurance otherwise don’t count
INCOMPLETE 0 If Name is equal to Alan, and if it is equal to Incomplete, count this task occurance otherwise don’t count

[oeldere]

maybe with an pivot table. see the attached file.