In column A I have data that contains names. Most entries have a commar between Surname and First name.

I need a formula that will count how many names (rows) have a commar in them. The numer of rows will change as names are added or removed


Thanks in advance.