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?