Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TOTALING VALUES IN A COLUMN
I have a database that has two columns:
1. Names of children 2. The language the child speaks at home I would like to set up a query that returns the TOTAL number of children that speak EACH language. How could that be done? -- William |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
TOTALING VALUES IN A COLUMN
Hi William
place cursor in first cellDataPivot TableFinish On the PT skeleton that appear on the new page, Drag Language from field list to Row Area Drag Language again to the Data area -- Regards Roger Govier "William" wrote in message ... I have a database that has two columns: 1. Names of children 2. The language the child speaks at home I would like to set up a query that returns the TOTAL number of children that speak EACH language. How could that be done? -- William |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation, totaling values based off dropdown lists | Excel Discussion (Misc queries) | |||
Totaling Different Cell Values | Excel Worksheet Functions | |||
Totaling cells consisting of values determined through concatenate | Excel Worksheet Functions | |||
Totaling up a column | Excel Worksheet Functions | |||
Random Values totaling Cell value | Excel Discussion (Misc queries) |