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 
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 
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 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 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 how do i stop predictive text in numbers Hi all does anyone know how to stop preditive text in numbers 09?view more 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 
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 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 
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 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 
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 
(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 
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 Contacts into spreadsheet Is there a program/way to convert Contacts listings into a spreadsheet?view more 
Text not printing I've created a basic table in numbers, but the content doesn't print, just the table outline. I've opened an older document which had previously been fine and again the content isn't printing, again just the tab...view more Numbers does not import CSV files properly Using Numbers v 3.6.2 under OS X El Capitan v 10.11.6 CSV files are not imported correctly. A file with 8 columns appears in Numbers as two columns with the first containing data from 7 columns and the second containi...view more Another popup menu question Is it possible to add to a popup menu by linking the cell with the popup menu to a column. as rows are added to the column, can they be automatically put in the menu of the popup cell? If not, is it poss...view more 
Can I use Search or Find to locate a comma or inverted commas in a text I was wanting to use formulas to locate commas etc in text strings. I'm new to mac and numbers and I can't find the correct way of entering the search-string when looking for commas or inverted commas. Always get inva...view more 
stop autofill in numbers Hi, I am just starting to use numbers. I used excel previously. I like a lot of things that numbers does, but the autofill is driving me crazy. I am a researcher and I need to type in data. The top lin...view more