counting multiple conditions

This is the data in your file:

Data Range

	A	B	F
1	Patient Number	Enrolment status
2	Patient 1	Enrolled - Active
3	Patient 2	Enrolled - Assertive	Active = 3
4	Patient 3	Enrolled - Maintenance	Assertive = 2
5	Patient 4	Discharged	Maintenance = 2
6	Patient 5	Closed without enrollement	Discharged = 1
7	Patient 6	Enrolled - Active	Closed = 2
8	Patient 7	Enrolled - Assertive
9	Patient 8	Enrolled - Maintenance
10	Patient 9	Closed without enrollement
11	Patient 10	Enrolled - Active

Exactly what do you want to count? All the cells that contain the word Enrolled?

This should give the result of 7

Formula:

Please Login or Register  to view this content.

Originally Posted by AlKey

=COUNTIF(B:B,"Enrolled"&"*")

=COUNTIF(B:B,"Enrolled*")

If "Enrolled" is ALWAYS at the beginning of the string:

=COUNTIF(B:B,"Enrolled*")

If "Enrolled" might be anywhere within the string:

=COUNTIF(B:B,"*Enrolled*")

You're welcome. We appreciate the feedback!

You could have your data in a table with a totals row on the bottom and then use the filter on the Enrolment Status column and enter in the Search box Enrolled or whatever term you want. Records containing Enrolled will be filtered out and the count shows in the totals row.Attachment 459285
Table filter & total 2.JPG