I have a list of Sales People's Names in "Column B", in "Column C" I have the
client name and in "Column D" I have an indication of whether the account is
"Active" or "Inactive" . In a summary field I want to calculate how many
"Active" accounts "Bob" has, then in another summary field show the number of
"Inactive" accounts "Bob" has.

I have done this before, but seem to be struggling with the formula this
morning. Any help would really be appreciated.

Thanks, Paul