hi..
I have been trying to use count ifs and Sums.. but im getting it wrong.. I am trying to look at two columns on the same worksheet and count the number of times a specified word comes up in column A and how many times a specified word comes up in column (B)..eg I want one cell to show that new york = 1 (winter) & another cell shows new york = 1 (george)
Thanks so much if anyone can help x
I have
column A
new york
new york
france
London
france
column B
Winter
George
George
Winter
Spring
I have been trying to use count ifs and Sums.. but im getting it wrong.. I am trying to look at two columns on the same worksheet and count the number of times a specified word comes up in column A and how many times a specified word comes up in column (B)..eg I want one cell to show that new york = 1 (winter) & another cell shows new york = 1 (george)
Thanks so much if anyone can help x
I have
column A
new york
new york
france
London
france
column B
Winter
George
George
Winter
Spring