Previous Topic Next Topic

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

Closed
Report
Posts
1
Registration date
Thursday May 12, 2016
Status
Member
Last seen
May 12, 2016
 -
Hi Everyone... Finding this really hard to figure out...

I have Cell A1:A50 Containing lots of names
And
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?