How can I order by alphabet the list created on a dropdown menu? How can I order by alphabet the list created on a dropdown menu?view more 
COUNTIFS specific year Hi, I'm having difficulty coming up with a formula that works, so I'm turning to the community for help. I'm not sure if it's my formula, or if it's possibly a data formatting issue, but I have a flight log, a...view more Conditional Formatting Rules Not Working I have OSX 10.10.5 and Numbers 3.6.1. I have been working with spreadsheets that use conditional formatting rules to apply a colored fill to cells. True values are filled green and False values are filled red....view more 
Getting Stock Quotes Into iWork 3.1 A few months back I was scouring this community for instructions on how to get stock information into iWork. Folks like Yan Koenig and Bob H. posted some suggestions and I think I was this close to success whe...view more 
Entering transactions in Numbers Hello, I am very new to numbers and making a budget. I am using a budget template found on Numbers on my ipad. So far I have filled out the budget sheet (entered my own expence categories and expences and budg...view more 
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