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
    10 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

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

          10 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
    9 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.