Hi,
I have set the following formulas:
=COUNTIFS($C$2:$C$351,"*Kellogg",$G$2:$G$351,"*CT")
I want to be able to count only if both the word Kellogg and CT are present.
I have attached the workbook. Does it matter than im working from a drop down list?
Any help is much appreciated.
Thanks
Bookmarks