averageif based on form response

Cody1434

Hello,

Had a quick question I haven't been able to find a solution to.

I need to average a column based on a different column containing part of a name.

So for instance a facility will do the survey and I need to average their response to a question. The facility may be put in a number of ways, but always contain "pittsburgh" for example. So I have tried:

=AVERAGEIF({Survey Range},CONTAINS("pittsburgh", {KPI Survey Range 11}))

where the first reference is the range to average and the second is the range to lookup the name in. However, this gives me the average for the total range, including other facility's answers. Any help is appreciated.

BullandKhmer

Try this...

=AVERAGEIF({KPI Survey Range 11},CONTAINS("pittsburgh"), {Survey Range})

Let me know if it works.

AJ

Cody1434

@BullandKhmer that didn't work, interestingly enough if I use AVG and just average the cells, I get the correct value of 0.65. However, when I try to us AVERAGEIF I get a 1 or a 0 based on whether or not the word appears in the lookup column. Almost as if it were just returning, true, false.