Hi everyone, Sorry for the confusing title but couldn't think how to describe it! I'm stuck on a formula at work and wondered if you can help?


excel.JPG

What I need to do is where there is a value in column D add all the values in column F until another value appears in column D again, then continue to do the same down the sheet.

Any help would be great.

Carl