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!

One way is to create a pivot table, with the agents' codes' col header placed
in the ROW area, then the different headings' col headers placed in the DATA
area, set to summarize by counts/sum as appropriate. Then in the pivot sheet,
just drag "Data" & drop it over "Total" to achieve a col format.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bella Gray" wrote:
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!