formula's

[time conversion]

what is the formula for taking one column of data (surgical procedures) and
another column of data (surgeons) and displaying the data in such a way that
it totals how many times each surgeon has done that specific surgery?

 

[Bob Phillips]

=SUMPRODUCT(--(A2:A20="surgeon"),--(B2:b20="procedure"))

 

[CurlyDave]

what is the formula for taking one column of data (surgical procedures) and
another column of data (surgeons) and displaying the data in such a way that
it totals how many times each surgeon has done that specific surgery?

Check out the SumIf formula

 

[Mike H]

Hi,

Try this

=SUMPRODUCT(--(A1:A31="Dr Mike")*(B1:B31="Breast Enhancement"))

In practice the doc's name any technique would be cell references

Mike