I need help to create some formulas to analyze an existing grid. On a seperate sheet I need to calculate some totals for certain references on another sheet. Each row of the sheet that needs to be anylized contains a row with a name and the word internal. What I need to extract is the following information.

1. How many total rows contain each name.
2. Of the rows where a certain name shows up, is the word internal in columnA.
3. Of the rows where a certain name shows up, is columnA empty.

So with this formula I will be able to tell that John shows up in 200 of the 1027 rows. Of the 200 rows, 150 of them have the word internal in columnA so the 50 remaining rows do not.

I assume this will be three seperate formulas. Any help would be greatly appriciated, thanks in advance.