Greetings,
Racking head on this. I have a column with dates, and need to only count the ones that have text in another column. Please help!
Col A - Name
Col B - Section
Col C - Training Date
There are 5 different sections in Col B.
Greetings,
Racking head on this. I have a column with dates, and need to only count the ones that have text in another column. Please help!
Col A - Name
Col B - Section
Col C - Training Date
There are 5 different sections in Col B.
Not real clear so this is only a guess...
=COUNTIFS(B2:B100,"*",C2:C100,"<>")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
THANK YOU! I was able to make it work by replacing the * with the section.
Good deal. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks