Thanks - not sure how you do that but here is a copy of the workbook. I am not sure how the upload works but if I click the carat next to the paperclip above the document appears to be there.
The data input being used is on the first tab 'data input' and I am trying to summarise that on the 'Sheet 2' tab.
On sheet 2 at cell D5 was my first rule set up that worked. Cell D6 was the next attempt being manually inputted and cells E6:J6 have been successfully pasted by copying D6 and then individually pasting each additional cell along row 6.
Oh I have spotted from the preview that the document is there.
Thanks