Counting a text Range if another text range has a value of....

mostro32 Posts 1 Registration date Thursday May 12, 2016 Status Member Last seen May 12, 2016 - May 12, 2016 at 11:19 PM
Hi Everyone... Finding this really hard to figure out...

I have Cell A1:A50 Containing lots of names
I have Cells C1:C50 Containing the Status of a project

I want to add in cell D1 the following:

If A1:A50 contains "MyName" and C1:C50 contains "Complete" Then count

This is so that I can see how many tasks I have finished and how many I have left over.
Anyone can help?