How do you do a simple formula to add row items in a column?
In Excel its easy - set the cell at the bottom of the column to Formula and put in =SUM(A1,A2,A3) where a1, A2 etc are the numbers of the cells you want to add.
In InDesign I assume you would need some sort of plugin.
found this:
https://support.apple.com/kb/PH17011?locale=en_US&viewlocale=en_US
Quote from: StudioMonkey on September 07, 2017, 03:56:32 AMIn Excel its easy - set the cell at the bottom of the column to Formula and put in =SUM(A1,A2,A3) where a1, A2 etc are the numbers of the cells you want to add.
In InDesign I assume you would need some sort of plugin.
I thought it'd be like that in Numbers too, but I can't figure out how to do it. It's probably there, but hidden. I just need to find the formulas.
I don't think Numbers is quite as robust as Excel. My wife is an Excel ninja... she was showing me things on the Windows version that weren't available on the Mac version, let alone in Numbers. I'm no Window's fan, but it does excel at Excel.
Can you export the Numbers file to an Excel file and then do it in Excel?
I'm pretty sure the world didn't need another spreadsheet program. Excel, Google Sheets, OpenOffice and Libre Office seem to have all boxes ticked. Excel is used here in some pretty interesting ways, we've got some people that can write nifty VBA.
If Apple wanted to be taken seriously they should have taken a clue from the other Excel clones and just kept the formulas the same so users wouldn't have the learning curve.
Quote from: DigiCorn on September 07, 2017, 11:04:59 AMQuote from: StudioMonkey on September 07, 2017, 03:56:32 AMIn Excel its easy - set the cell at the bottom of the column to Formula and put in =SUM(A1,A2,A3) where a1, A2 etc are the numbers of the cells you want to add.
In InDesign I assume you would need some sort of plugin.
I thought it'd be like that in Numbers too, but I can't figure out how to do it. It's probably there, but hidden. I just need to find the formulas.
Sry I didn't realise that 'Numbers' was the name of an app . . . :old:
OK I found this - ignore the URL its a tutorial on how to do stuff in Numbers
https://www.gadgetdaily.xyz/get-a-web-app-to-emulate-a-mobile-app-on-android/
[Edit] Ignore that you have to scroll down thru what looks like years of articles
There's this
https://computers.tutsplus.com/tutorials/how-to-create-a-basic-spreadsheet-using-numbers--mac-56895
or this
https://www.youtube.com/watch?v=z3sNrjO7QsE
While Numbers does not come close to Excel when it comes to functionality, it is basic spreadsheet program that looks nice and can be made to look pretty.
Sum is basic function and works in same way as in Excel.
You have to use "Insert Formula" and choose Sum.
Formula is very is similar to Excel, e.g. SUM B2:D2 will add B, C and D columns in Row 2 together.
Really, they key to anything with formulas is the start with an "+" in the cell. That brings up everything you need. The copy and paste is simplified too - literally just drag the yellow dot. It does take some getting used to, and all you can export is a .csv.
What's this new permissions bullshit in Numbers now, where you apparently can't work on excel files anymore? Used to be that you'd open up a file from excel, save it as a .numbers file or export to a .csv. Now there's all this permission crap and it basically doesn't work at all anymore.
And yes, the file is unlocked with all options set to "Read & Write"
Where are you trying to save it to? (try the documents folder)
It used to work off the server, but then that stopped working.
I started dragging to the desktop and dragging back, but then that stopped. I'll try that out and get back to you. Thanks.
In the meantime, I have to walk across the room and use a Windows 7 box with Excel on it to open the file, and save as a .txt then walk back to import the file for data merge. It's stupid. I should just be able to open in numbers, export as .csv and be done with it. It's like 10 seconds of my time vs. a minute.
#FirstWorldProblem
Quote from: Joe on May 09, 2019, 12:04:15 PM
Where are you trying to save it to? (try the documents folder)
Nope. Doesn't work either - same error message
[edit] It
might be this... https://support.apple.com/en-us/HT203538
I'll check it out when I can and report back
Yeah there are times when it won't let me save something to the desktop but it will let me save it to the documents folder. Then 5 minutes later it will let me save to the desktop. Personally I think it is because Mojave is a piece of crap!
:pileofpoo :pileofpoo :pileofpoo
I was eventually able to export a .csv but ONLY when the file was relocated to the desktop and exported to Documents. There was no other combination that worked, and I could only export the file - not save it.
I tried resetting permissions, and have "Read and Write," chosen to every conceivable location, including the hidden Library in Mojave. I followed these directions, (http://www.macinstruct.com/node/415) but still no good... even after reboot.
Remember when you could repair permissions with Disk Utility? Ahhhh the good old days.
The only time I use numbers is when I want to save a PDF from an excel file. Much easier to have everything saved onto one page in a PDF with Numbers then in Excel. Everything else I just use Excel as it is the standard and much easier to get what you need done as someone has most likely already done it.
So I found a solution. Basically, you have to create a "Numbers" folder on the iCloud, and then work exclusively out of that folder alone. If you need to export shit, then you have to do so in that folder, and then drag it where it needs to reside.