I have a task that involves working with two applications, Graphical Query
Language (GQL) and MS Excel. I am currently dumping data from our Oracle
database through GQL and into Excel. I have two spreadsheets, one that will
hold the dump and the other that will contain the structured report with
graphs located on 34 different tabs within the worksheet containing different
Departments within our organization.

What I would like to do is, after the initial dump, transfer that data from
spreadsheetA and copy that data systematically into spreadsheetB populating
all graphs with that information for our VPs.

The issue is: I have a survey that calculations need to be applied against,
there are questions that are asked and then those questions will be evaluated
by counting the number of each response pertaining to each question answered.
Each answer will hold its own calculation on a graph on spreadsheetB related
to that department.

How can this be done?

Count the number of :
Very Satisfied
Somewhat Satisfied
Neither Satisfied or Dissatisfied
Somewhat Dissatisfied (Please explain)
Very Dissatisfied (Please explain)


In each column for each depart with totals.
Is this the right way to use this formula?

=COUNTIF('FW FILE DUMP'!A2:A216,DEPARTMENTS!A3=SUMIF('FW FILE
DUMP'!C1:C209,DEPARTMENTS!A52))

This is what I am trying to do:

IF the list of Departments in WorksheetA in cells A2:A216 = 'ADMISSIONS AUTH
& TRANSFERS' AND the cells answers in WorksheetA related to that department =
'Very Satisfied' Count how many times 'Very Satisfied' appear for that
department in WorksheetA.

This is what I am saying but how do I put it in a formula format so it will
work?

Have you tried Pivot Tables?


YouthHelp wrote:
I have a task that involves working with two applications, Graphical Query
Language (GQL) and MS Excel. I am currently dumping data from our Oracle
database through GQL and into Excel. I have two spreadsheets, one that will
hold the dump and the other that will contain the structured report with
graphs located on 34 different tabs within the worksheet containing different
Departments within our organization.

What I would like to do is, after the initial dump, transfer that data from
spreadsheetA and copy that data systematically into spreadsheetB populating
all graphs with that information for our VPs.

The issue is: I have a survey that calculations need to be applied against,
there are questions that are asked and then those questions will be evaluated
by counting the number of each response pertaining to each question answered.
Each answer will hold its own calculation on a graph on spreadsheetB related
to that department.

How can this be done?

Count the number of :
Very Satisfied
Somewhat Satisfied
Neither Satisfied or Dissatisfied
Somewhat Dissatisfied (Please explain)
Very Dissatisfied (Please explain)


In each column for each depart with totals.
Is this the right way to use this formula?

=COUNTIF('FW FILE DUMP'!A2:A216,DEPARTMENTS!A3=SUMIF('FW FILE
DUMP'!C1:C209,DEPARTMENTS!A52))

This is what I am trying to do:

IF the list of Departments in WorksheetA in cells A2:A216 = 'ADMISSIONS AUTH
& TRANSFERS' AND the cells answers in WorksheetA related to that department =
'Very Satisfied' Count how many times 'Very Satisfied' appear for that
department in WorksheetA.

This is what I am saying but how do I put it in a formula format so it will
work?