Hi, I'm trying to do a countifs, that will count the number of cells with the criteria 'Adults' in column A, that have one of the following criteria in column B; 'Active assignment', 'secondment', 'acting up'.
I'm writing the following but recieving a circular error:
=COUNTIFS(Fire!$F:$F,"826...