I am using counta(c5:c33) to return value if something is type in a cell I do not what to count this if there is an x or Admin type in a cell who if c6 has anx in its not counted and if another cell has admin its not counted I think it bray be be a countif formular but cannot seem to work this out help
Bookmarks