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

Closed

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
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?

Counting a text Range if another text range has a value of....
Excel if range of cells contains specific text then return value ✓ - Excel Forum
Selection.autofill destination:=range ✓ - Excel Forum
If statement with date range - Guide
Count if cell contains number - Excel Forum
Excel take screenshot of range - Guide

Subscribe To Our Newsletter!