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