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

Attached Files

Draft Organsational_Accident_Trend.xlsx (58.9 KB, 9 views)