Assuming table columns are A and B, respectively.
=SUMIF(A:A,"para",B:B)/COUNTIF(A:A,"para")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jesse Blanchard" wrote:

sorry if this is a dumb question, not too familiar with excel: I am working
on a report that, in part, is tracking how long patients stay in the spinal
cord injury center according to their injury (for example: paraplegic,
tetraplegic).

I need to get the average for the number of days for patients with each type
of injury. I have two columns, one with the number of days they stayed and
the other with a dropdown list of injury type (para, tetra). How do I get the
average for only those patients that have a para injury type?