Hello everyone,
I am trying to filter specific items in the customer column by order numbers that contain a grey fill. For example, I am wanting to see how many order numbers have an order for shoes. I have tried using the CountIf and CountIfs formula. The specific formula I used was =COUNTIFS(F:F, "*shoes*", E:E, "*>1*") The answer I got with that formula was 0. I can count and see there are four order numbers that have an order for shoes, but I want to get the answer with Excel or VBA.
Is there a way this can be done?
Screenshot (260).png
Bookmarks