USING SUMPRODUCT

[Trevor Aiston]

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

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[Max]

=SUMPRODUCT((PID=Attendee)*(Day=2))

Presuming your Day range contains real dates
think you could try something like this:
=SUMPRODUCT((PID=Attendee)*(Weekday(Day,2)=2))
Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---