how to calculate across sheets Hi. I have a Numbers document with multiple sheets. How can I calculate the subtotals from each sheet in one cell on the last sheet? Thanksview more 'Questions students missed the most' graph I'm a math teacher, and want to get a graph and some stats about which questions were missed, and have a nice visual graph of that and get some statistics from there. I'm having trouble getting this done, not sure if ...view more volume size to support permanent storage of Numbers File I have a Numbers file that I store in an encrypted disk image. Every time I exit, after making a change to the file I get the following message - "The document “Words handheld.numbers” is on a volume...view more numbers text to rtf or pages (without formatting) i have a very comprehensive list of items in two columns that i would like to move to a pages or rtf document. i have removed the cell colors and the outlines and seem to have been able to paste it into a rtf ...view more Auto-Populate Agenda Hi, I'm trying to automatically populate a "Daily Agenda" from a "Task Chart" as in the picture below. When the date of the daily agenda is changed I'd like the tasks and details from my task chart to automatic...view more how to print selected cells in numbers Does anyone know how to print selected cells in a Numbers spreadsheet, rather than printing the entire sheet? Also, how to save the selected cells as a pdf file without saving the irrelevant cells?view more Transpose column from one table to row headers in another and populate with data from original table Hi, Similar to one of my previous posts, I am trying to extract data from a column based on a "text" value when a match is found in another. The the example shown below, I am attempting to populate Table 2 wit...view more IF funktion Hi, I have a checklist and if B3 is checked the value of F3 is displayed in G3 and G should accumulate (see screehshot) (IF B3=TRUE;F3) works with row 3 to accumulate I used the formular (IF B4=TRUE;F4+G3) but...view more This may be tricky... So I have a couple amortization tables (not shown) that I'm working on with one for 5 and one for 10 years. In this graph (that works off the amortization tables) I'm working with results from each table. It's c...view more メニューバーが英語のままで日本語に変更出来ない メニューバーが英語のままで日本語に変更出来ないview more Excel 2011 Corrupt Files from .xlsm I've been dealing with this issue for several months. I receive an .xlsm file from a remote coworker, who is Windows based. Opens perfectly the first time after receiving. Then I work on the file, save and close. Go t...view more Calculate the mean per time slot ? Hi Chaps, I'm an absolute beginner on Numbers (almost everything on Mac i would say) and i need help to calculate mean values. Those are calculated values (Column 2) taken on a precise moment of the day (Colu...view more Find percentage of double false pairs within five two column sets The situation is that I have four sets of two related columns, and those four sets are repeated over 17 sheets. They are all check boxes (basically and either or), and I've already got it set up to do quite a bit when...view more key / (divide), doesn’t work key / (divide), doesn’t work in formula (instead print + ), what to do?view more in the previous version, the menu table in table options, there is an option that gives me the option: the Return key moves to next cell. I do not see this option in the new number. can you help me please? in the previous version of Number, the menu table in table options, there is an option that gives me the option: the Return key moves to next cell. I do not see this option in the new number. can you help me ple...view more Pie Chart references not working I have a table with a column of averages in column P. The labels for the averages are in column B. I click C to insert the chart, then pie chart, then add data. I click "wedges" to allow me to identi...view more Extracting text from strings in a single cell from a row of cells Hi, Is there an easier way to lookup a text / word in a string within row of cells and where a match is found return a header text - see example shown below. The table on the left contains the original comp...view more linking sheets I have a very simple spreadsheet/database in Numbers. There are several sheets for various geograpgic regions. There is one sheet at the front that I would like to contain links that take the user to a regional sheet....view more Numbers Sort Capabilities (Macbook Pro mid 2009; OS10.11.6; Numbers 3.6.2 I have been searching but cannot find an answer to:- If I have added a sort column then how do I delete one or more of the selected rows/columns in the sort - or even just reset my sort options? I see that I ...view more I need to get 2 decimal places when using a formula for a quotient and Numbers will only give me whole integers which is useless since most items will be less than 1. How can I change this? How do I get 2 decimal places when using a formula for a quotient? It only gives me whole integers. Most of the results will be less than 1 so I need 2 decimal placesview more