Why not something like
=SUMPRODUCT(--(TEXT(MISDATA!$G$3:$G$5000,"mmm-yy")=TEXT($A39,"mmm-yy")),MISDATA!$I$3:$I$5000) - SUM(the other six values to the left)best wishes--Bernard V LiengmeMicrosoft Excel MVPhttp://people.stfx.ca/bliengmeremove caps from email"Alexey" wrote in . .. 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 ofthe data together I have five similar to the above - the difference is just the name of theperson in the H3 column. My problem that I would like a 7th column whichwill 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