Hi

I am analyising a lot of data. I am using:
=SUMPRODUCT(--(TEXT(MISDATA!$G$3:$G$5000,"mmm-yy")=TEXT($A39,"mmm-yy")),--(MISDATA!$H$3:$H$5000="Paul
Mumford"),MISDATA!$I$3:$I$5000) to pull a lot of the data together

I have five similar to the above - the difference is just the name of the
person in the H3 column. My problem that I would like a 7th column which
will incloude all others names in H3 other than the six above. Can you say
.... < "Name1" and < "name2" and < "Name 3" etc..?

Else has anyone any other idea how I can do this?

Thanks

A