New answers tagged numbers
Of course there may be other ways of doing this, but here is one. To accomplish this dynamically (so that it changes when the current week changes), one can use the WEEKNUM( ) function. Create a column (you can hide this later if you don't want it to show. See edit below) with the calculation of: WEEKNUM( A1 ) -- Where A1 is the first cell with a date. ...
I found out that you can use the SUMIF function to accomplish this: SUMIF(test-range, condition, sum-range)
Don't know if it works for .xls files as well, but you could try this: Go to: Safari > Preferences > General > Untick "Open "safe" files after downloading".
When left-clicking it downloads automatically to your default (Downloads) folder, and is directly opened in the default Application. This is standard OS X behaviour. You can change the default App to open the .xls file as @IronCraftman describes in his answer. To only download the file and not open it (hover over the attachment icon) and right click and ...
Right click on an Excel file. Click: "Get Info" Set the "Open with:" selector dialogue to whichever app you choose. In the "Open with:" section, there is "Change All..." button to change all files with the same extension.
Hopefully someone knows how to source data from multiple table inputs, but I just use brute force and make one table that contains all data I need to chart. Tables can refer to data from multiple other tables, so now with your charting data in one table, chatting becomes a snap.
As far as I can see, chart titles and labels (and text boxes) can't contain formulae. So I think this isn't possible in the ways that you suggest. An alternative is to place a single-cell table on top of the chart, with the cell containing a formula like = "Salaries normalised to " & B1 & " school days". I'm using Numbers '09... hopefully this ...
Generally, what is done is to create a Column Header. You already have a perfect example of this in the table shown in your question. Row 1 contains field names for each data record. i.e.: "Image", "whale_00", etc. (See "Work with Rows and Columns" in Numbers Help) Select Row 1 and convert to Header Row If you wish, you can create a header row with ...
Try entering function as = DAY(NOW())&"/"&MONTH(NOW())&"/"&YEAR(NOW())
Make sure the source columns are formatted as the proper date/time format.
Top 50 recent answers are included