condensing multiple fields in different columns

[time conversion]

I have two columns of data....one column has surgical procedures, many of
them exactly the same. I have another column of surgeons, also many of them
are the same. How do I condense the data to count for example: all the Hernia
Surgeries done by one particular surgeon???

 

[CurlyDave]

You don't need to ask the question multiple times

 

[Rasoul Khoshravan]

I have two columns of data....one column has surgical procedures, many of
them exactly the same. I have another column of surgeons, also many of them
are the same. How do I condense the data to count for example: all the Hernia
Surgeries done by one particular surgeon???

Surgical procedure in column A, Names in Col B
In column C type:
=sumproduct(--(A1:A10="Name of the surgical procedure"),--
(B1:B10="Name of surgeon"))
This will count number of specific surgeons for specific procedure.
Instead of typing the parameters inside "" you can use a cell
referenced to them. Is this clear?

 

[smartin]

I have two columns of data....one column has surgical procedures, many of
them exactly the same. I have another column of surgeons, also many of them
are the same. How do I condense the data to count for example: all the Hernia
Surgeries done by one particular surgeon???

Use a pivot table. Select your two columns, fire up the pivot table
wizard, put procedures in row area, surgeons in column area, and either
variable in the data area.

This will produce a grid showing counts of procedure x surgeon.