Conditional SUM statements

[swk]

I am attempting to analyze the raw data from a survey (I may already be in over my head, but here goes!)

The responses from each survey are in rows, with the columns representing each question. Each cell contains a number, representing the answer provided, in a range from 0 - 11. Each question has a different range of possible answers (0, being a no response or blank).

I have summarized the demographic questions in another section, with one row for each potential answer to each question (0, or blanks omitted) using COUNTIF statements. I am now attempting to create a comparative grid that provides an easy look at select portions of the data. I have tried using SUM(IF as an array to compare two columns, but the results keep coming back 0.

Am I going the long way around this?

swk

 

[xlhelp]

Hi, I have been working with surveys for quite some time now. I do understand most of what you are asking except for:
I am now attempting to create a comparative grid that provides an easy look at select portions of the data.

If you could provide a little more detail then perhaps I might be able to help.

Thanks.

Indu

 

[swk]

The first question asks about a facility's ownership (range of answers 0-4) a second asks about management. I am trying to determine how many member-owned facilites are professionally managed, how many by the owner directly, etc.

The grid idea has the count of each possible answer to the questions of importance in rows and columns, something like a wind chill grid, so that I can compare each of the factors against each other.

It is entirely possible that my limited thinking (and experience of advanced Excel techniques) is making this harder than it needs to be. I have explored a pivot table, but there are some issues with the raw data I need to resolve first.

HTH and TIA

swk

 

[xlhelp]

It would be easier if I could take a look at the file. Would you mind sending the file or a portion of it to xlwrdhlp@yahoo.com ? I will not be able to look at it till later tonight.

HTH

Indu

 

[swk]

Yahoo reported a problem with SMTP when I tried to send the file. It says you do not have a valid account on Yahoo.

Its only 107K so size should not be the issue. email me at mailto:swkaeppel@recipnet.com and perhaps we can work something out

TIA

swk

 

[xlhelp]

File sent back to you directly

HTH

Indu