Hi, I am trying to use the countifs function to count the total number of times i can see both the word "sales" and "marketing" in a list. The function i've typed in is =countifs(A1:A12,"sales",A1:A12,"marketing"). The result I get is zero. When I've tried using this function with one or the other (sales or marketing but not both), I get a result. Any suggestions? Many thanks!