Hi, I'm really struggling with this formula, I'm sure there must be a way to
do it, but I just can't work it out!

I would like to sum values in a certain column in a database against
criteria set out in a cell.

I've got two sheets in my workbook, one with all the data, and one where I
need the data translated to. So my database is Sheet1!A1:M100 which counts
information, signups, calls etc which is all split according to different
agents. Each agent has a unique code in the format "MP23050" which are in
the data sheet. On Sheet2 I want to be able to identify the totals for each
agent under the various different headings.

I'm sure there must be a way to do it, but I'm really struggling
here...please help me!