count if name appears in column if not check next column and count if not check next column etc.

[confused in Frankfurt]

Hi there,
I have a set of data where the sales rep. creates a visit report. His name can appear in one of 6 fields.

I want to count the number of visits and only once per sales rep. per visit. The name can appear on one of 6 columns and not always in the first.

How can I count the first and move on to the next until reaching the last column without counting more than once per line? I also have a date span to query as well in order to count per quarter.

I am not using VBA and need a formula for Excel in the 2010 version.

Regards
and thanks in advance.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Report Creator
[/TD]
[TD]Attendee 1
[/TD]
[TD]Attendee 2
[/TD]
[TD]attendee3
[/TD]
[TD]attendee 4
[/TD]
[TD]attendee 5
[/TD]
[TD]Visit Date

[/TD]
[/TR]
[TR]
[TD]John Black
[/TD]
[TD]Mary Jones
[/TD]
[TD]John Black
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]21.01.2014
[/TD]
[/TR]
[TR]
[TD]John Black
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]15.01.2014
[/TD]
[/TR]
[TR]
[TD]Mary Jones
[/TD]
[TD][/TD]
[TD]Mary Jones
[/TD]
[TD]John Black
[/TD]
[TD][/TD]
[TD][/TD]
[TD]11.01.2014
[/TD]
[/TR]
[TR]
[TD]James Green
[/TD]
[TD]James Green
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]11.01.2014
[/TD]
[/TR]
[TR]
[TD]James Green
[/TD]
[TD]James Green
[/TD]
[TD]Mary Jones
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]01.04.2014
[/TD]
[/TR]
</tbody>[/TABLE]

Results: Q1 Q2
John Black 3 0
Mary JOnes 2 1
James Green 1 1