Filter/search and count.

[edsashley]

morning,

I have been using a formula for a while now which works fine. =COUNTIFS(F:F,”Dave*”,H:H,”*”). This will count the cells in column F that have Dave in as long as column H is also filled. I have to do this for different names.

I am trying to streamline this by inputting names into a drop down list in cell ‘O9’ and using whatever is selected as my variable.

I have tried amending the formula to =COUNTIFS(F:F,”=O9*”,H:H,”*”) but this does not work.

Can anyone offer any suggestions please.

 

[edsashley]

Apologies. I have only just realised this. Attached is a better screenshot. The search criteria table populates the drop down located at ‘O9’ highlighted green. Whichever is selected from here is what needs to be in the formula of K6.

Thanks for any help.

 

[edsashley]

Just for everyone’s information. I’ve resolved this now. My fault, I neglected to say there would be more information than Dave ie Dave Smith. I wanted to filter by Dave from my drop down so the formula had to have wildcards in as follows.
=COUNTIFS(F:F,”O9 & “*”,H:H,”*”)

This now works and filters by all the Dave’s, Dave Smith, Dave Jones…etc.

Thanks for the guidance all.

 

[Peter_SSs]

Attached is a better screenshot.

But..

• We still cannot see column F
• Column H is completely blank as far as we can see

This sis still relevant:

I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be. We can also copy from it for testing.
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)