Average and Conditions

**ggutier49** · 12-23-2008, 03:20 PM

hey guys

Im pretty new to Excel but have been picking it up pretty well. I am creating a quarterly report for a medical facility and kinda stuck. I have a column that has two types of conditions (say A & B) and then a couple columns over i have 3 columns that all have numbers in them. On a seperate sheet i am trying to get an overall average of all the numbers in these three columns if they match a certain condition(A of B)

therefore, i am trying to get the averages of all three numbers from the columns on all the patients as long as they meet the condition in the previous column.

I hope this makes sense and please email if you think you can help but need further information.

ggutier49@gmail.com

**daddylonglegs** · 12-23-2008, 03:44 PM

Let's say the condition is in column A and the numbers in D,E and F. You can use a formula like this

=AVERAGE(IF(A2:A100="A",D2:F100))

This is an array formula that needs to be confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula in the formula bar.

Note: if there are any blanks in the number range then these will be treated like zeroes and may give a false average. To counteract that you could change the formula as follows

=AVERAGE(IF(A2:A100="A",IF(D2:F100,D2:F100)))