LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AP AP is offline
external usenet poster
 
Posts: 11
Default How can I calculate the numbers?

Hi all

I'm busy capturing a staff survey.

I need to calculate the number of times the staff members answered "Agree,
Disagree, etc" to questions 1 - 26 from a specific area.

Let's say:

Column A: Question No
Column B: Question
Column C: Region
Column D: Answer

A B C
D
1 I am very satisfied with my job. Eastern Cape Agree
5 Staff are encouraged to develop. Gauteng Disagree
8 Staff are paid fairly for the work. Western Cape
Strongly Disagree
7 Management make a real effort. KZN Agree
1 I am very satisfied with my job. Eastern Cape Agree

Please help, I'm really stuck with this one.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate variance between numbers? copitta Excel Worksheet Functions 5 May 24th 16 03:22 AM
Calculate only Positive Numbers B G Excel Worksheet Functions 3 June 23rd 06 03:09 PM
I want to calculate the average of best 5 out of 7 numbers? Attempt at solving a Matrix Problem? Excel Discussion (Misc queries) 7 September 28th 05 08:08 PM
Calculate sum of numbers with conditions Curtis Excel Worksheet Functions 12 July 16th 05 07:36 AM
Calculate In-Between Numbers Brenda Rueter Excel Worksheet Functions 7 May 10th 05 04:07 PM


All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"