Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I can't find any equivalent of the Excel Pivot Table or Open Office Data Table features. I'd like to sum up my data grouped by values in various columns.

For example, if I have

A       B       C
red     left    2
red     left    3
green   left    4
green   right   4

I want to be able to get

        red     green   all
left    5       4       9
right   0       4       4
all     5       8       13
share|improve this question
Apparently there is a categories feature that gives some of this power, but I'm still looking for a better answer. – Kevin Peterson May 26 '12 at 0:56
What led you to think pivot tables are implemented in Numbers. It's not there AFAIK. – bmike Apr 13 '13 at 20:33

Assuming the tables are named Original and Pivot, the cells in Pivot are filled using this formula:

=SUMIFS(Original::$C, Original::$A, "="& $A2, Original::$B, "="& B$1)

i.e. sum values in Original::$C if

  • corresponding value in Original::$A = value in first column of Pivot
  • corresponding value in Original::$B = value in first row of Pivot

The 'all' values are just simple sums of those rows or columns.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.