count instances based on two criteria

[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

 

[Frank Kabel]

Hi
try something like
=SUMPRODUCT(--('data'!B1:B100="Adams"),--(D1100="major"))

or use a pivot table. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

 

[Myrna Larson]

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.