Pivot table. Function SUM arguments

[iren]

I am trying to build a Pivot table.

1. I put labeled Age-group into row area(data type char)
2. put labele "Region" into columns area(data type char)
3. Put allowed sum into Data area (data type delimited number)
As the result I got counts ..Of regions and age group
While I need SUM of allowed sum totals

I went to formula bar and opened Function symbol. I choused SUM(). However, system requests arguments for the function.
What arguments range should I specify? Horizontally, vertically? I tried to highlight data area but it did not help. I looked at Help and did not understand yet. Could you please give me a hand (example)as I never handled with a Pivot table. How can I specify arguments for SUM function?

Thanks you in advance,
Iren

Grand total
Region Middleast National
Age_grp

<1 3 3 .... 17
15-17 3 4 .... 18
18-19 3 2 .... 15
20-24 17
..
GrandTotal 59 50 .........

 

[Kiwiman]

Rt Click on your pivot table, and select Pivot table wizard, Select layout,Double click on the field in the data area, and select sum from the "summarised by" list - it will currently show count

Take it Easy
Man with one chopstick go hungry