I have a workbook of attendees and their results on a course evaluation sheet
for each day,

In the workbook there are two worksheets
Attendees which lists all those attending the three day course with column
A PID a unique personal identifier for the course attendee the whole
colum is a
named range PID (other colums name inc etc)
DATA which records answers to evaluation questions with the PID entered
in to
column A and Column B DAY (which is also a named range DAY) recording which
day the avluation sheet refers to

I've been trying to use the following formulae in worksheet ATTENDEES to
show if a PID attended on a particular day
=SUMPRODUCT((PID=Attendee)*(Day=2))
I followed the example in help changing the values to suite but I alswasy
get 0!

HELP

Trev