Counting function??

[Simon]

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

 

[Shailesh Shah]

Hi Simon,

It is better to create Pivot Table, see more details in
VBA Help.

Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/

 

[Bob Phillips]

Simon,

If you definitely don't want a Pivot table, you can get the numbers with

=SUMPRODUCT((A1:A100="Joe A")*(B1:B1000="Shipping")

etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Shah Shailesh]

Hi Simon,
You have to look in Excel Help for creting Pivot table.

Also look below link for such post answered by Rob Bovey.


http://www.google.co.in/groups?hl=en&lr=lang_en&ie=UTF-
8&oe=UTF-8&newwindow=1&threadm=%23RMK1lAtDHA.628%
40tk2msftngp13.phx.gbl&rnum=1&prev=/groups%3Fas_q%

Ragards,
Shah Shailesh

 

[Simon]

Thanks Bob it worked