Help: With Excel Formula's

[shephardfamilyenterprise]

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 VP’s.

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 it’s 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 department with totals.

[SlaveToTheMan]

First, cross-posting is frowned upon in almost every forum I've seen. Try to pick the most appropriate one to your topic and leave it at that.

Second, this is really a forum for Printing & Prepress related discussions. Excel is much like the ugly step-brother we all know exists, but we prefer to keep it locked in the basement & fed scraps from the dog bowl.

Third, the text size - c'mon. Really?

Fourth, Stickies are for important topics. Why they allow Members to post them as such, I don't know. Admins, do what you do best.