help with averages formula
 

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?

help with averages formula
 

Hi Jesse
Try this array formula
=AVERAGE(IF(B13:B22="tetra",A13:A22)) you need to enter it with Ctrl Shift
Enter
HTH
John
"Jesse Blanchard" wrote in
message ...
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?

help with averages formula
 

Hi Again
Just in case you're not familiar with ARRAY formulas
You must enter that formula by pressing CTRL-SHIFT-ENTER to activate
the array. you'll see curly braces { } around your formula if you do it
right .
Everytime you edit that formula, you must press Ctrl-Shift-Enter for it to
work.
Regards
John
"John" wrote in message
...
Hi Jesse
Try this array formula
=AVERAGE(IF(B13:B22="tetra",A13:A22)) you need to enter it with Ctrl
Shift
Enter
HTH
John
"Jesse Blanchard" wrote in
message ...
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?