count the number of members in cells seperated by ;

OK, so the logic would be something like:

IF the cell is empty then 0;
IF the cell has no semicolon then 1;
In all other cases, (number of semicolons + 1)

Or, more simply:

IF (the cell is empty, 0, (number of semicolons + 1))