Macro to Summarise a Spreadsheet

[Macca_GB]

Hi, I have limited experience of writing macros and need some information analysed and summarised on the same sheet. In the attached I need each row analysed. So row 2 the info is for WOKING (D:2). In columns I,J, there could be a number. If there is a number in cell I:2, I need this added to the summary field Cell F:52. If there is a number in cell J:2 I need this added to to the summary field F:51. I then need to go to the next row and carry out the same analysis. Each site has a reference in the summary field. Any data found within cells in columns I & J should be accumulated in the summary fields.

Your help is appreciated.