I want 'sum', not 'count'...

[Lester]

Hi
I created a pivottable with the wizard-tool, but it insists on counting the number of entries of a given type, rather than summing them together.

anyone know how to make it sum the values rather that count the number of values?

thanks

[Bob Phillips]

You could right-click the items in the pane and in Field Settings change COUNT to SUM

[Lester]

You could right-click the items in the pane and in Field Settings change COUNT to SUM
Thanks, but it already says SUM in the field setting...I think it must be something to do with when I created the pivotTable when the wizard asks you to identify the rows, columns and table data.

I think I'm struggling to explain myself clearly...thanks anyway.

gracias...i mean 'thanks'!

[Bob Phillips]

Why not post the workbook?

[Lester]

Why not post the workbook?
I'm not sure what a workbook is, to be honest. The work I'm doing contains employee-sensitive data, so I doubt it would be possible to post it.
Cheers

[Lester]

I've posted the workbook (now that I know what one is) and I've de-sensitised the content. The pivotTable in question appears on 'sheet 3'.

Can anyone help with my original question? Thanks.

[Paul_Hossler]

Your PT source data included rows 1 - 147, except 113- 147 were empty.

Excel will COUNT if there data field contains text (or blanks).

I changed the source data to only use rows 1 - 112 and then could change the COUNT to SUM

Paul

[Lester]

Your PT source data included rows 1 - 147, except 113- 147 were empty.

Excel will COUNT if there data field contains text (or blanks).

I changed the source data to only use rows 1 - 112 and then could change the COUNT to SUM

Paul
Thanks for this, Paul. I can see that the source data finishes at row 112, but how did you know the PT source data included rows 113-147? How did you manage to change the source data to (correctly) only use rows 1-112?

You can tell I'm new to this game, can't you?!

Regards
Lester

[Bob Phillips]

Select the pivot table, goto Data>Pivot ... and then hit the back button, you will see the range.

[Lester]

Select the pivot table, goto Data>Pivot ... and then hit the back button, you will see the range.
Excellent. Thanks...I can successfully correct the range (which removes the '(blank)' entry, but it still shows 'Count' instead of 'Sum'. Any ideas how to correct this?

Thanks.

[Paul_Hossler]

In the PT Layout, click the data fields, and select each of the two data fields to change COUNT to SUM

Paul

[Bob Phillips]

Excellent. Thanks...I can successfully correct the range (which removes the '(blank)' entry, but it still shows 'Count' instead of 'Sum'. Any ideas how to correct this?

Thanks.

I answered that early in this thread.