Hi, I'm fairly new in using excel formulas and have encountered a small dilemma. I've searched the net for formulas but nothing returns the result that I'm looking for. Anyway, here's what I want to achieve:
I want to count how many times the value "Personal" occurred in a column (that can simply be done by a countif formula) BUT I don't want excel to count the cells with the value "Personal" IF on the same row in another column the value "Cancelled" is found.
Can this be achieved? Thank you
Bookmarks