COUNTIF using 2 ranges??

[snickstx]

OK, here's the deal. I have a worksheet with about 500 rows of data, o
each row has a unique ticket number, a type code (1-9) and a compan
name (about 20 different companies) What I need to do is get th
results for each company and each code. Therefor, the number o
tickets that belong to company XYZ that have a code of 3 would b
entered into one field. Then 4, 5, 6 etc.

I have tried COUNTIF and array formulas but have has no success. I
you have any ideas, please share.
Thank

 

[DDM]

Snickstx, a pivot table will give you what you are looking for. All you have
to do is set up a table with Company and Type Code as row headings, and
Count of Ticket Number in the data area. You can find information on setting
up a pivot table here:
http://www.peltiertech.com/Excel/Pivots/pivottables.htm and here:
http://www.contextures.com/xlPivot01.html, as well as in Excel help.

 

[Don Guillett]

try using data>filter>autofilter

 

[snickstx]

Thanks for the great replies. After some trial and error I ended u
using:

=SUMPRODUCT(('WORKSHEET'!L2:L1000="COMPAN
NAME")*('WORKSHEET'!I2:I1000=CODE NUMBER))

I had tried this previously but had inadvertantly left the sort i
place on the original worksheet. This left text in the number fiel
and caused the #N/A error. After spending some time in this forum
was able to uncover my mistake. Hope this helps anyone else having
similar problem.
Thanks Again!!