Count Text within Multiple Selection on a Drop Down List

[digbee]

Hello,

I have used a macro to ensure I can select multiple options from a drop down list, which is fantastic and works.

However the drop down list are names, and I need to count how the names.

I am not sure how to do this, pleas see attached spreadsheet for additional info.

Any help would be greatly appreciated!

Thanks

Jodie

[Glenn Kennedy]

In sheet3 B7:

=COUNTIFS(Master!$H$5:$H$2000,"*"&A7&"*",Master!$J$5:$J$2000,"")

[digbee]

I was close just not close enough, thanks so much Glenn

[Glenn Kennedy]

Execl is a curse... so pernicketty about syntax.

You're welcome.

---

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

It would also be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

[digbee]

so sorry Glenn it worked yesterday and I have come in this morning to sort the spreadsheet and its not working.. I know its probably something silly but could you have a look for me please?

[Glenn Kennedy]

Nope. It was ME being silly, not looking closely enough at your data.

Use:

=IF(A11="","",COUNTIF(Master!$I$5:$I$2000,"*"&A11&"*"))

copied down to the total row.

[digbee]

Hi thanks that certainly pulled through numbers for the names on the list, but I was looking to only have ones pulled that did not have dates in column K? So sorry for this!

[Glenn Kennedy]

In your sample ALL odf the date columns are completed. Hence no results are returned. That's why I removed that bit. Delete a few dates here and there.

However, it's still better to use

=IF(XX="","",formula)

all the way down the boxes. Done for the yellow shaded cells, only.

[digbee]

Hi,

I took one of the dates out and kept one of the dates in and its returning names

e,g, on attached it should technically only pull through Siobhan but its pulling Kate Ward as well.

My brain is officially fried! haha!

Thanks

J

[Glenn Kennedy]

It NEEDS to be fried... You used the wrong version of the file. Close ALL others and use this one ONLY. It has a NEW and DISTINCTIVE name.

[digbee]

ok, clear!

Thank you so much I am away for a strong gin...

[Glenn Kennedy]

You have my permission!

You're welcome.

---

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

It would also be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.