Re: Pivot Table sum incorrect

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Dave,

I think you need to look closely at the contents of the last December entry. Pivot tables
will accept either text or numbers, but if they're text, and there are spaces included,
they'll ignore it. What is the formatting (Format - Cells - Number) of the cells? If you
select the errant December cell, click in the formula bar and move the cursor with the arrow
keys, do you see any extra suspect stuff? This kind of thing can happen with imported
data, data pasted from web pages, and stuff like that.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Dave" <djbahb@xxxxxxxxx> wrote in message news:ei5CCnwSHHA.488@xxxxxxxxxxxxxxxxxxxxxxx
I have a pivot table summarizing a medical expense spread *** for the year. All total
and subtotals are correct except for December. There are 3 entries for December, however,
the pivot table will not recognize the very last spread *** entry, therefore the grand
totals are off by those amounts.

How can I find the range December is looking at when summarizing the data?

Thx in advance
Dave



.

Quantcast