Looking up data/keyword and then adding it together as a summary value

Dear all,   I've got absolutely no idea where to start with this so I thought I'd come here and ask the gurus!   So I have a sheet full of sales forecasting data that I want to be able to lookup ...