I am trying to sort through a survey of results.
each row starts with the date and the information is gathered in a pre set
values. i.e good, verygood etc.(Note there are several rows with the same
date)

I have tried V look up yet I need the search criteria of the look up to be
able to cope with the dates being the same.

Altenativly I used the COUNTIF option, yet I need to know how I can make the
"A38949" reference below. to change with the value I have in the results list.

(Note A38949 is the date with an A added so that Count IF function
recognised a date.)

=COUNT(IF((Analysis!$A$3:$A$2000="A38949")*(Analys is!$H$3:$H$2000="excellent=1"),Analysis!$Z$3:$Z$20 00))

I would then apply the formula to a list of dates I need to know the results
for.

Hope you can help.