I am trying to count number of external employees. There are two columns,
Column F with values EXT for external and INT for internal employees
Column G with date.
Now, if date column is empty this means that employee is here since last year. I need this as my starting point for my other calculations, i.e. how this number changed through months of this year. So this is what i found in different sources, but this formula is returning 0
=(COUNTIFS(F2:F130;"EXT";G2:G130;">"))
i guess that there is error in second criteria
thanks