Counting???

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Hi,

Right this is my problem, I have a master spreadsheet in
which I want to count how many queries are coming in for a
specified person.

So for example Joe A and Joe B are on the phones, their
names are in Cells A1:A10 another spreadsheet called for
example "Incoming Calls". Everytime one of them recieves a
call they put their name in the "A" cells, e.g A1=JoeA,
A2=JoeB,A3=JoeB etc. So it can be totally random but every
time they put their name down they also need to put down
the query they recieved. E.g A2="JoeB", B2="Complaint".

I would like to use the name as the key so on the master
spreadsheet I know how many "Complaints" Joe A or B have
dealt with or any other queries.

I think its some sort of COUNTIF function but I can not
get it to work.

Any help would be much appreciated.

Many Thanks in advance.

Simon
..
 
A bit more detail along with your definition of "spreadsheet". Do you mean a
worksheet or a workbook?
 
Right its a worksheet in Excel 2003.

Caller Query
Joe A Complaints
Joe B Complaints
Joe A Complaints
Joe A Shipping
Joe A Refund
Joe B Complaints
Joe A Complaints

Above is what my worksheet looks like. In another
worksheet I need a formula for a cell to count how
complaints/shipping queries each caller takes. So for
example in my results sheet it should show:

Shipping Complaints
Joe A 1 3

I need a formula to do the above??

Any help would be very much appreciated.

Many Thanks in advance.

Simon
 
=SUMPRODUCT(--('Sheet2'!A2:A100="Joe A"),--('Sheet2'!B2:B100="Complaints"))


or better

=SUMPRODUCT(--(Sheet2!A2:A100=C1),--(Sheet2!B2:B100=D1))

where C1 holds the name and D1 the type of call
 
Peo said:
=SUMPRODUCT(--('Sheet2'!A2:A100="Joe
A"),--('Sheet2'!B2:B100="Complaints"))


or better

=SUMPRODUCT(--(Sheet2!A2:A100=C1),--(Sheet2!B2:B100=D1))

where C1 holds the name and D1 the type of call

--

Regards,

Peo Sjoblom


Peo, you saved my weekend!
Click to expand...
 
Back
Top