First data cell not counted in pivot table...

I think you should attach example excel file first then ask about pivot table

To attach an Excel file to your post,

• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post

Should be now?!

Hey guys, you are amazing!!!

try this one

That one is correct.
But you had to add a row and extra data.
Ther should be no need to do that.

Why is mine not giving correct figures?
There is no reason for it, as far as I see it.

Pivot Table works with columns and content not with rows only
in your example first row is treated like headers for columns

maybe read here: How Pivot Table works

Thank you for this source to learn more about the pivot table. I will surely dive into it :-)

But I really think what I present is one of the most essential tables you can have: 3 columns.
For the pivot table: one for the rows, one for the columns and one for the data.

An addition of those data values should be made of the first 2 rows, period. "huish" = 1000 (first row) + 500 (second row) = 1500, which should be the value for "jan".
Or am I overlooking something???

Yes, I just figured that out also. See my latest screenshot and your updated file with arrows and color.
Thank you. Problem solved :-)

You defined headers for columns and it's correct for Pivot Table

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it already - ignore it.
Thank you.

New screenshot...

see post #12

Thanks for the feedback
and remeber ... for a PivotTable first row will be treated as Headers and it will be not counted in PivotTable
Doesn't matter there will be 1,2,3... or names - name1, name2, name3.... - it will be treated as headers - alwayas

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.