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?

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

--
__________________________________
HTH

Bob

"time conversion" wrote in
message ...
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?

On Feb 7, 3:22*pm, time conversion
wrote:
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

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

"time conversion" wrote:

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?