Need a formula to capture the completed status for a relevant data

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

Hi,
use this in cell J5 and fill down:

Formula:

=COUNTIFS($B$5:$B$13,I5,$C$5:$C$13,"Completed")

Originally Posted by wcymiss

Hi,
use this in cell J5 and fill down:

Formula:

=COUNTIFS($B$5:$B$13,I5,$C$5:$C$13,"Completed")

Thank you so much wcymiss.. this helped a lot ur a Rockstar!!!!!

I am sure if I need any help in future I can directly PM you.

Thanks Again

Wasim