I have some data in Apple Numbers spreadsheet in the following sample format.
1.A $2
2.B $1
3.A $1
4.C $1
Now, I would like to have a spreadsheet in the same file to be updated automatically (based on the info in the above table) in the following format.
1.A$ 3
2.B$ 1
3.C$ 1
Please help me how to do this?
Enter the data in a table named "Data" as shown (the table on the left):
The create a second table (which I called "Summary").
enter the categories in the first column, as shown, then use the formula as shown below...
select cell B2,
now type the equal sign
now copy or paste from here the formula
SUMIF(Data::B, A2, Data::C)
type the return key
shorthand for this is:
B2=SUMIF(Data::B, A2, Data::C)
select cell B2, copy
select cells B2 thru the end of column B, paste
Hi Coder_sls,
Just jumping in here after reading all the helpful replies in this thread.
Starting with Wayne's suggestion for the Data table, duplicate that table and rename it as something like Data with Categories.
Formula in A2 =Data::A2
Fill down and fill right.
Don't worry about the zero (0) results. We can fix them.
Now apply Categories to the table on the right
I am posting now to avoid the timeout restriction.
More later,
Regards,
Ian.
Coder_sls wrote:
categories approach changes the order and formatting. In my raw data table, it is in a particular order as per the date and I don't want to change that...
Reg. your comparison point with Pivot table, there is an option to create all the processing/filtering in a separate sheet in there.
Ah, I see your point about Pivot Tables. They do leave the original data unchanged.
So if you want to use Categories, the closest equivalent to Pivot Tables in Numbers and a really powerful feature, you could just duplicate the table and apply Categories to the duplicate. I think that is what Ian is illustrating. To duplicate a table, click in it, click the "bulls-eye" upper left to select it as an object, command-c to copy, command-v to paste.
If you're having trouble getting SUMIF working you might restudy Wayne's post above. If you learn better from video tutorials then you could try this one.
And by all means post a screenshot of your actual data so someone here can help you better.
SG
Data Analysis on Apple Numbers
