Hi,
use this in cell J5 and fill down:

Formula: copy to clipboard
=COUNTIFS($B$5:$B$13,I5,$C$5:$C$13,"Completed")