Two Reasons Your PivotTable Counts Instead of Sums Values

↔️ ↕️


hello and welcome to this video tutorial


in this video we are going to look at

why your pivot table

is counting your values instead of

summing them

now your pivot table will always default

to summon

numeric values in your pivot table the

only reason to

count them is when it believes they are


and we're going to look at the two key

reasons why it may

think that now first of all

what i think is the the main reason

are blank cells and i've got two

examples of what i mean here

this first example i've got but for us

is quite a clear blank cell

in the totals value common bear in mind

Related queries:

how to not sum values in pivot table
do not summarize values in pivot table
how to change summarize values in pivot table
pivot table summarize values by
pivot table keeps summing values