Counting cells with a text value

Hi,

I'm trying to figure out a to COUNT the number of items that are in-progress and the items that are complete/done. But my counts are based on two keys one being the status, the other being someone actually being assigned to that item. Since their could be anyone working on those items, my question is how do I check if the cell has a value or not and use it with the COUNTIFS function.

See the example I'm working on below.

A	B	C	D	E
TC1	RQ1	In-Progress	Jane	=COUNTIFS($C$:$C$6,"In-Progress",$D$2:$D$6,"I'd like to know what should I use here to check if cells in column D have a value
TC2	RQ2	Done	Mike
TC3	RQ3
TC4	RQ4	In-Progress	Melissa
TC5	RQ5	Done	Don
TC6	RQ6	In-Progress	Peter

Hi neverTL,

Looks like this formula works:
=SUM(IF(ISNUMBER(A1:D1),1,0))
Find the attached with examples
Count cells using If IsNumber.xlsx

After rereading your question you might really want to change the "IsNumber" to "IsText" in my formula above.

Hi,

=COUNTIFS(C:C,"In-Progress",D:D,"?*")

Regards

Originally Posted by neverT00late

Thank you, but this didn't work for me.

You need to clarify to whom you're replying.

Regards

Originally Posted by neverT00late

This work just as I expected. Thank you. Is '?*' basically a syntax for wildcard?

You're welcome. Actually it's using two wildcards: the ? to indicate that the cell begins with a text character, the * to indicate that that text character may be followed by more characters.

Regards

I guess I better read the question a bit harder next time. Thanks to XOR LX for understanding the question.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.