Hello all.
can someone help me with a countif formula. I know how to use countif to look for text in a column but what i want to count text in a column and in another column at the same time.
For example, in the attached sheet you will see Column N has Mr Shafi and column F shows done/not done. can i use a single formula count the done and not not against mr Shafi or is it 2 formulas?
Bookmarks