Hi All,

This might be the easiest one for you all.

I have attached the the excel sheet where in i want to calculate the total number of completed data points for one person.

Let's say "Wasim" would have completed 7 tasks and would updated the relevant cell as Completed.

Now in a huge data list How will i find "Wasim" and how do i calculate how many he has completed.

I believe Pivot table would be the answer here but is there any formula which would replace the pivot table?

I am in need of this as soon as possible any help will be much appreciated.

(Please see the attachment)
Keeping my fingers crossed.Example.xlsx

Thanks,
Wasim