Numbers Crashing on SierraI'm running Numbers 3.6.2 on macOS Sierra Build 16A304a (Public Beta 6) on a mid-2010 MacBook 2.4GHz Core 2 Duo with 8GB RAM. I have an Expenses spreadsheet where, as the name suggests, allows me to input all ...view more
Thread Once a certain number is reached in tally -drop to zero
Once a certain number is reached in tally -drop to zeroI have a column with each row successively larger as each row contains the tally of the row above it plus a new figure. HOWEVER, once the tally comes to a certain number (found in a separate cell) I want all further r...view more
Sharing Numbers sheet, 2 iphonesMy husband and I use Numbers for budgeting purposes. Right now all he gets is a "copy" on his iphone and if updates with receipts it only updates his copy. Is there a way to share the sheet between two iphones (we hav...view more
Can I print each table on a new page?When using Numbers, I often have multiple tables within any given sheet. Like this: When I print the sheet, this often causes tables to be split onto multiple pages. Like this: It's v...view more
Want to auto populate a popup menuHi! I'm looking for a way to auto populate a popup menu with data from a column on a separate sheet. On Sheet 1 I have a bunch of products names listed in column A (with their prices and taxes in columns B onwards.). ...view more
Maximum number of simultaneous filtersHi, I've found out that when reaching 8 different filters on a spreadsheet, the option to add a new filter gets greyed out. Is there a possibility to increase that number? Thank you.view more
numbers column recallHi, I'm using numbers v3.6.1. We have a database of all equipment we own with rows stating the make, model number, serial number, description price per day and so on. What I want to be able ...view more
COUNTIFS specific yearHi, 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 WorkingI 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.1A 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 NumbersHello, 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 rangesI 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 NumbersThoroughly 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
That SUMIF function - an idiot questionThis 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
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
