Survey manipulation data

[Guest]

Hi, I created a worksheet where I enter the results of a survey I'm doing. I
made some fórmulas that are work fine. I also used the subtotal function that
works fine when I use Autofilter to filter the data. My problem is that I
used Countif to make some calculations according to the specified answer but
I would like to use filter with them and I don't know how. Can anybody help.

Thanks

izlopez

 

[Dave Peterson]

Kind of a general question, so kind of a general response...

This was posted by George Simms a long time ago:

Headings in Row 1

=SUMPRODUCT((A2:A10="A")*(SUBTOTAL(3,OFFSET(A2,ROW(A2:A10)-ROW(A2),,1))))

This will count the number of A's that are visible in column A (with a filter
applied to A1:x10).

 

[JulieD]

Hi

you also might like to check out Advanced Filtering and the Database
functions - e.g. DCount which counts the number of items that meet a
criteria.

see http://www.contextures.com/xladvfilter01.html for general information on
how to use advanced filtering

and DCOUNT or Database functions in Excel help.

Cheers
JulieD

 

[Guest]

Thanks for the answer but let me be more specific as you ask. I am conducting
a survey on evaluation of trainers. I created a spreadsheet where I enter the
results. The first row is the header of the columns and the rest is the data.
I created the formulas at the end of each column. When I want to see the
results for a question regarding an instructor, I apply autofilter and select
the one I want to see, but that works fine to obtain averages, and to count
the total entries, but when I want to see how much answered let's say
"completly satisfied" or "not satisfied", I can't find a way to use filter
and get an accurate result. I used Countif, but it doesn't apply the formula
when I use filter because it counts all the entries, no matter the filter I
apply. Finally I would like to make charts of this information per instructor
and per course. For this I tried using PivotChart, but I don't know why I
can't find a way where it give me results per type of answer, by instructor
and by course.

Thanks,

Ivette

 

[Dave Peterson]

I'm not quite sure, but it sounds like a pivottable may be what you want to use.