count instances based on two criteria

  • Thread starter Thread starter jfrisco
  • Start date Start date
J

jfrisco

I would like to perform the following:
list the number of major and minor surgeries performed by a specifi
doctor.

ex: adams major surgeries 6
adams minor surgeries 8
jones major surgeries 15
jones minor surgeries 11

from a spreadsheet layed out

date | doctor | procedure | major/minor

any ideas? please tell me if I need to give more information

Jennife
 
If you eventually want to get this information for all doctors, I would use a
Pivot table. Doctor as a row field, Major/Minor as a column field, Major/minor
as a data field using Count.
 
Back
Top