Hi all
I have a formula that simpl counts the number in a column that is equal to a certain word.
=COUNTIF(owssvr!C:C,"Initiate")
This looks up the tab then the column in the tab then the specific word and counts them.
What I am trying to do now is also use column A as I only want the formula to count the word initiate to the ones in column A that is equal to the word open.
At the moment it counts them all, which picks up collumn A which has cancelled, closed and so on.
Is this possible?
Regards
Matt
Bookmarks