How to set up a query on a survey in Excel

[andco 10]

I'm using Excel to analyse survey feedback results. Entered all the raw data and now want to query the responses in a particular field. How do I go about this? Do I want to use Pivot Table or can I just set up a query and if so how do I go about doing so?

[CuMo 10]

Something similar?

 

http://office.microsoft.com/en-gb/excel-help/customize-a-parameter-query-HP010216113.aspx

[andco 10]

Thanks CuMo - I'm starting from the most elementary level of spreadsheet use which is simply SUM = (XXXXXETC) for expenses and related outgoings. No idea how to even setup a parameter Seeing a real live person on Friday who has said they'd be able to help me

 

---------- Post added 10-09-2014 at 09:25 ----------

 

They said that I need to familiarise myself with the "IF ... THEN" command