MacMost Now 475: Adding Up Amounts In iWork Numbers
The simple task of adding a column of numbers in iWork Numbers can be done elegantly using right-sized tables with footer rows. Learn how to easily add a list of amounts and perform other function like averages using iWork 09 Numbers.
Want to know more about how to use Numbers on your Mac? Check out this MacMost course!
Related Subjects: iWork (42 videos), Numbers (185 videos)
Related Video Tutorials:
No related posts.
Comments: 5 Responses to “MacMost Now 475: Adding Up Amounts In iWork Numbers”
Mehdi
13 years ago
Hi Gary,
thanks for the video, i am trying move from Excel to iWork, but there are many adds-in for Excel which they do not work with iWork e.g. Isoplot which i need it for my job, is there any way to use them with iWork?
Also another problem is, the Isoplot adds-in needs VB, and as you know, the Mac OS does not support VB any more, i need this for my job and i really do not know what to do? should i necessarily install windows on my mac (which i really hate it)? or do you have a solution for running such programs on Mac which they need VB?
If you need those specific things, you will either have to find replacements on the Mac side, or just run Windows using Parallels, VMWare or Boot Camp -- and run Excel inside that. Have you tried the new Office for Mac 2011? Does that do what you want?
Mehdi
13 years ago
no, i have not tried the new office yet, but it might help, i will try it once...
is there any way to use the Excel Adds-in in iWork?
I'm pretty sure there is no way to use Excel add-ins in iWork. They were written for Excel and would only work there.
Ruth Poles
12 years ago
I have successfully txfd my excel spread sheet into Numbers and was able to "add a row above" but now that option is greyed out? Also how can I add multiple rows? Also, the sum at the bottom of the amount column just stays the same?
Hi Gary,
thanks for the video, i am trying move from Excel to iWork, but there are many adds-in for Excel which they do not work with iWork e.g. Isoplot which i need it for my job, is there any way to use them with iWork?
Also another problem is, the Isoplot adds-in needs VB, and as you know, the Mac OS does not support VB any more, i need this for my job and i really do not know what to do? should i necessarily install windows on my mac (which i really hate it)? or do you have a solution for running such programs on Mac which they need VB?
Many Thanks
Mehdi
If you need those specific things, you will either have to find replacements on the Mac side, or just run Windows using Parallels, VMWare or Boot Camp -- and run Excel inside that. Have you tried the new Office for Mac 2011? Does that do what you want?
no, i have not tried the new office yet, but it might help, i will try it once...
is there any way to use the Excel Adds-in in iWork?
I'm pretty sure there is no way to use Excel add-ins in iWork. They were written for Excel and would only work there.
I have successfully txfd my excel spread sheet into Numbers and was able to "add a row above" but now that option is greyed out? Also how can I add multiple rows? Also, the sum at the bottom of the amount column just stays the same?