Sum up a list with a pivot table

A pivot table groups a long list and adds it up. Drag fields to change what it shows.

2 steps3 minutesPlans: Free, Personal, Pro, Enterprise

  1. 1

    Click in the list

    Any cell with data.

    Click in the list
  2. 2

    Press PivotTable

    On the Insert tab, at the left.

    Press PivotTable

Was this helpful?

We count yes and no per article. Nothing about you is stored.

Still stuck? Ask us.

People, not a bot. We answer within one working day.