ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   TOTALING VALUES IN A COLUMN (https://www.excelbanter.com/excel-discussion-misc-queries/224884-totaling-values-column.html)

William

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

Roger Govier[_3_]

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




All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com