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.

Comments: 5 Responses to “MacMost Now 475: Adding Up Amounts In iWork Numbers”

    Mehdi
    9 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?

    Many Thanks
    Mehdi

      9 years ago

      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
        9 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?

          9 years ago

          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
    8 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?

Comments Closed.