Hi All,

A first time poster here looking for some help!!

Thought I was competent on Excel until I embarked on this!

I am analysing my company's history of job per postcode/zip code. I have got as far as getting all of the raw data into an excel sheet and have managed to write the forumal to automatically attribute a numberical or points value to each job type. The points values are all pre-defined by my company.

I have then filtered that data by month and copied the monthly data onto their own sheets within my workbook. However, now I am trying to create a formula where I can find multiple jobs completed within a partial post or zip-code and then total the allocated points. (The postcodes/zip codes are in column C and their point values are in column E). I am really struggling to write a fomula that finds the multiple entires in column C and then tallies up their point values in column E.

I hope that this makes sense and that someone can assist!

Kind Regards,

Jonathan