r, Good morning.
"...Thanks for that. I don't think that is what i was after...
The formula that was suggested to you is exactly what you need.
"...I don't think i explained it very well...
Your need is a simple process to understand.
Since you have sent us only one image of part of your spreadsheet, I will adapt the formula by changing the intervals for what we can see.
You should adjust your formula to the reality of your data.
=SUMPRODUCT((Sheet1!$B$2:$H$111=C142) * (Sheet1!$A$2:$A$111))
If you prefer, save your worksheet to some free website, www.sendspace.com and place the download link here.
It's faster and easier for us to help you.