Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with averages formula | Excel Discussion (Misc queries) | |||
Formula help with averages and if then statements | Excel Worksheet Functions | |||
Averages formula/0 | Excel Worksheet Functions | |||
averages formula | Excel Worksheet Functions | |||
averages formula | Excel Worksheet Functions |