• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
:
Communities
  • Contact Support
      • Sign in
    • Content
    • People
    • Search
    • Support Communities
    • iWork
    • Numbers for Mac
      • All Content (26292)
      • User Tips (9)
      • Discussions (26283)
      • Thumbnails
      • Details
      • Hierarchy
      Filter by tag
      Previous1234Next
      • Thread Numbers formula help using date ranges

        Numbers formula help using date ranges

        I hope I can explain what I am needing well enough to make sense. I have two charts.   One is used to track job bids in the form of money, dates, total awarded and so forth. This chart contains a date column (Co...view more
        t quinn
        last modified by t quinn
        • 0
        • 1
        Numbers formula help using date ranges

        in Numbers for Mac

          Back
        • Thread MS Excel and Mac Numbers

          MS Excel and Mac Numbers

          Thoroughly confused new guy here.  Run an Excel spreadsheet (2013) on Windows 7 and just bought a new MacBook Air 13 with Numbers.  Discovered my MacBook can "read" my Excel spreadsheet downloaded on USB dri...view more
          notcloudy
          last modified by notcloudy
          • 0
          • 4
          MS Excel and Mac Numbers

          in Numbers for Mac

            Back
          • Thread Formula works in one row, but same formula (copied and pasted) will not work in other rows.

            Formula works in one row, but same formula (copied and pasted) will not work in other rows.

            I have a formula that, if there is a number in the box, multiplies it by a price, then sums the results in a final column. I copied it into 7 rows. It changed the row numbers as necessary, the formulas all look right,...view more
            Maddog_Walby
            last modified by Maddog_Walby
            • 0
            • 4
            Formula works in one row, but same formula (copied and pasted) will not work in other rows.

            in Numbers for Mac

              Back
            • Thread That SUMIF function - an idiot question

              That SUMIF function - an idiot question

              This is my first attempt at spreadsheeting and like my first attempts at skateboarding I seem doomed. However I have persevered and with help from forum members have made a very useful financial tool. I now have a s...view more
              David Graeme-Baker
              last modified by David Graeme-Baker
              • 1
              • 2
              That SUMIF function - an idiot question

              in Numbers for Mac

                Back
              • Thread Formula or counting a specific letter in a row or area ?

                Formula or counting a specific letter in a row or area ?

                At the moment, I am creating a water polo stats sheets that records a players stats by assigning them certain characters. I need a formula that counts a specific letter in a row or an area of cells and displays the co...view more
                t quinn
                last modified by t quinn
                • 0
                • 1
                Formula or counting a specific letter in a row or area ?

                in Numbers for Mac

                  Back
                • Thread Sum total income for each unique client and chart it!?

                  Sum total income for each unique client and chart it!?

                  Greetings from sunlit Athens!  I have been scouring for the past 5 hours for an elegant solution to the following:   I would like to sum the total amount of income for each unique client and chart it to vis...view more
                  t quinn
                  last modified by t quinn
                  • 0
                  • 11
                  Sum total income for each unique client and chart it!?

                  in Numbers for Mac

                    Back
                  • Thread How can I create a chart that creates new series every year when the data is not collected daily?

                    How can I create a chart that creates new series every year when the data is not collected daily?

                    I collect numbers from my solar system "occasionally", and want to create a normalized graph that shows that generation on a yearly basis so I can compare fall to fall each year, etc.   Since the information is ...view more
                    Wayne Contello
                    last modified by Wayne Contello
                    • 0
                    • 3
                    How can I create a chart that creates new series every year when the data is not collected daily?

                    in Numbers for Mac

                      Back
                    • Thread Using page number / page count in formulas

                      Using page number / page count in formulas

                      Hi.   I'm seeking for a solution, that I can display a value/text in a cell (If…then…), e.g. when the page count is higher then 1.   Unfortunately 'Numbers' (3.6.2) couldn't handle the page n...view more
                      t quinn
                      last modified by t quinn
                      • 0
                      • 2
                      Using page number / page count in formulas

                      in Numbers for Mac

                        Back
                      • Thread SUMIF row is equal to test value and row below is '-'

                        SUMIF row is equal to test value and row below is '-'

                        Hello,   I have a numbers spreadsheet where one column has a list of names that are mixed up with repeats, and another column that has a list of profit values relating to that name.   Now, I want to determ...view more
                        t quinn
                        last modified by t quinn
                        • 0
                        • 12
                        SUMIF row is equal to test value and row below is '-'

                        in Numbers for Mac

                          Back
                        • Thread Using Applescript to copy cells from one document to another

                          Using Applescript to copy cells from one document to another

                          Hi!   I just finished completing my first "Real" Applescript to do something that I thought would be fairly simple. It only took me 5 days to figure out!   Anyway, I regularly create new Numbers document...view more
                          Wayne Contello
                          last modified by Wayne Contello
                          • 0
                          • 2
                          Using Applescript to copy cells from one document to another

                          in Numbers for Mac

                            Back
                          • Thread how do i stop predictive text in numbers

                            how do i stop predictive text in numbers

                            Hi all does anyone know how to stop preditive text in numbers 09?view more
                            Wayne Contello
                            last modified by Wayne Contello
                            • 0
                            • 4
                            how do i stop predictive text in numbers

                            in Numbers for Mac

                              Back
                            • Thread How do I remove the border around a chart?

                              How do I remove the border around a chart?

                              Not the chart border that aligns with the max and min x- and y-axis values, but the border that is outside the x- and y-axis labels.view more
                              T2YUKI
                              last modified by T2YUKI
                              • 0
                              • 8
                              How do I remove the border around a chart?

                              in Numbers for Mac

                                Back
                              • Thread What is the title of the highest rated item from 2016?

                                What is the title of the highest rated item from 2016?

                                I have titles (Table 1::B) that are labeled by year (Table 1::A) and have a percent value (Table 1::E) assigned to them.   In Table 2 I have used an AVERAGEIF formula to determine the average percent of anythin...view more
                                t quinn
                                last modified by t quinn
                                • 1
                                • 2
                                What is the title of the highest rated item from 2016?

                                in Numbers for Mac

                                  Back
                                • Thread disregard negative numbers

                                  disregard negative numbers

                                  I have a column of numbers that I want to add, but I only want to add positive numbers and disregard negative numbers. How to do it?view more
                                  pamfrombalwyn
                                  last modified by pamfrombalwyn
                                  • 0
                                  • 1
                                  disregard negative numbers

                                  in Numbers for Mac

                                    Back
                                  • Thread Running Cumulative Totals On Numbers

                                    Running Cumulative Totals On Numbers

                                    Hello All. I am new to Mac and have only recently begun dabbling with Mac Numbers. I am currently trying to make a rudimentary spreadsheet for my Gas Payments with a small two column wide data set. One Column would r...view more
                                    t quinn
                                    last modified by t quinn
                                    • 0
                                    • 6
                                    Running Cumulative Totals On Numbers

                                    in Numbers for Mac

                                      Back
                                    • Thread Numbers upgrade - can't find field to edit!

                                      Numbers upgrade - can't find field to edit!

                                      Sorry if I'm being dense here, I'm sure there's an obvious answer that someone here will know but I just cannot fathom it nor find any info already online.    I've just upgraded from Mountain Lion to El Ca...view more
                                      jacquelinedanson
                                      last modified by jacquelinedanson
                                      • 0
                                      • 3
                                      Numbers upgrade - can't find field to edit!

                                      in Numbers for Mac

                                        Back
                                      • Thread Export to csv with fomulas

                                        Export to csv with fomulas

                                        I want to export file to CSV that saves cell fomulas instead of calculated values. Is it possible? I know OpenOffice can do that.view more
                                        SGIII
                                        last modified by SGIII
                                        • 0
                                        • 3
                                        Export to csv with fomulas

                                        in Numbers for Mac

                                          Back
                                        • Thread (Not sure was posted)  Text in numbers does not print even when saved as pdf or xls doc.

                                          (Not sure was posted)  Text in numbers does not print even when saved as pdf or xls doc.

                                          I'm using an up-to-date MacBook Air and an HP printer.  Thanks for any help you can provide.view more
                                          linkheng
                                          created by linkheng
                                          • 0
                                          • 0
                                          (Not sure was posted)  Text in numbers does not print even when saved as pdf or xls doc.

                                          in Numbers for Mac

                                            Back
                                          • Thread returning a count from months

                                            returning a count from months

                                            I am looking to return a count from months.  Example: 1/12/16 1/14/16 2/14/16 3/5/16   If these were in the same column I would want to return 2 for jan, 1 for feb, and 1 for march.   can anyone h...view more
                                            SGIII
                                            last modified by SGIII
                                            • 0
                                            • 2
                                            returning a count from months

                                            in Numbers for Mac

                                              Back
                                            • Thread Contacts into spreadsheet

                                              Contacts into spreadsheet

                                              Is there a program/way to convert Contacts listings into a spreadsheet?view more
                                              marywbennett
                                              last modified by marywbennett
                                              • 0
                                              • 2
                                              Contacts into spreadsheet

                                              in Numbers for Mac

                                                Back
                                              Previous1234Next

                                              This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.

                                              • Support
                                              • Apple Support Communities

                                              Shop the Apple Online Store (1-800-MY-APPLE), visit an Apple Retail Store, or find a reseller.

                                              • Apple Info
                                              • Site Map
                                              • Hot News
                                              • RSS Feeds
                                              • Contact Us
                                              • Choose your country or region

                                              Copyright © Apple Inc. All rights reserved.

                                              • Terms of Use
                                              • Updated Privacy Policy
                                              • Cookie Usage