[macvoiceover] Re: Entering formulas in Numbers
- From: John Panarese <jpanarese@xxxxxxxxx>
- To: macvoiceover@xxxxxxxxxxxxx
- Date: Tue, 26 Jun 2012 17:26:14 -0400
I'm not sure what you mean. For example, if I want to add up all the
items in a column, it would look like this, =sum(A2:A10) as the range. This
should work. Unless I am misunderstanding what you are asking. Please let me
know if I am not getting your question.
Take Care
John D. Panarese
Director
Mac for the Blind
Tel, (631) 724-4479
Email, john@xxxxxxxxxxxxxxxxxx
Website, http://www.macfortheblind.com
APPLE CERTIFIED SUPPORT PROFESSIONAL FOR MAC OSX LION
AUTHORIZED APPLE STORE BUSINESS AFFILIATE
MAC and iOS VOICEOVER TRAINING AND SUPPORT
On Jun 26, 2012, at 5:18 PM, Ian Edwards <ianedwards42@xxxxxxxxx> wrote:
> Thanks John. It's doing fine with formulas involving the plus sign, like
> d7+e7 etc. It's a range I'm having truble with. When I go to the formula edit
> box, I get imbeded cell fields, for example imbeded c7 plus imbeded c8. When
> I try a formula with a range like sum, there is no punctuation or symbol
> between the imbeded cell fields. So it doesn't say sum(imbeded c7:imbeded
> i7), instead the cells are smushed together.
>
> Does that make sense to you, and if it does make sense, is this right? All
> the guides I've read are about dragging and clicking and making sure the
> colours match up, not typing in the raw formula. Any suggestions would be
> helpful.
>
> Ian
>
> On 2012-06-26, at 2:39 PM, John Panarese wrote:
>
>> This looks fine. Instead of hitting enter, try navigating right to a
>> confirm button. I use formulas in my spreadsheets and it's the same process
>> as in Windows as far as I can recall.
>>
>>
>> Take Care
>>
>> John D. Panarese
>> Director
>> Mac for the Blind
>> Tel, (631) 724-4479
>> Email, john@xxxxxxxxxxxxxxxxxx
>> Website, http://www.macfortheblind.com
>>
>> APPLE CERTIFIED SUPPORT PROFESSIONAL FOR MAC OSX LION
>>
>> AUTHORIZED APPLE STORE BUSINESS AFFILIATE
>>
>> MAC and iOS VOICEOVER TRAINING AND SUPPORT
>>
>>
>>
>> On Jun 26, 2012, at 4:21 PM, Ian Edwards <ianedwards42@xxxxxxxxx> wrote:
>>
>>> Starting to play around with the Nurbers spreadsheet, and clearly I'm
>>> getting somethign wrong.
>>>
>>> I hit the equals key, and it starts a formula. I then type in my formula,
>>> say sum(c7:i7) and hit enter, but I get whacky values. It's addings some
>>> things up, but not my whole range of cells.
>>>
>>> Ok, I'm taking my formula typing from my experience with Excel, is there a
>>> different way of entering them in Numbers? I assumed there was a math
>>> language standard.
>>>
>>> Thanks for help to anyone who has experience with the Numbers spreadsheet.
>>>
>>> Ian
>>>
>>>>
>>>> Click on the link below to go to our homepage.
>>>> http://www.icanworkthisthing.com
>>>>
>>>> Manage your subscription by using the web interface on the link below.
>>>> //www.freelists.org/list/macvoiceover
>>>>
>>>> Users can subscribe to this list by sending email to
>>>> macvoiceover-request@xxxxxxxxxxxxx
>>>> with 'subscribe' in the Subject field OR by logging into the Web
>>>> interface at //www.freelists.org/list/macvoiceover
>>>>
>>
>>>
>>> Click on the link below to go to our homepage.
>>> http://www.icanworkthisthing.com
>>>
>>> Manage your subscription by using the web interface on the link below.
>>> //www.freelists.org/list/macvoiceover
>>>
>>> Users can subscribe to this list by sending email to
>>> macvoiceover-request@xxxxxxxxxxxxx
>>> with 'subscribe' in the Subject field OR by logging into the Web
>>> interface at //www.freelists.org/list/macvoiceover
>>>
>
>>
>> Click on the link below to go to our homepage.
>> http://www.icanworkthisthing.com
>>
>> Manage your subscription by using the web interface on the link below.
>> //www.freelists.org/list/macvoiceover
>>
>> Users can subscribe to this list by sending email to
>> macvoiceover-request@xxxxxxxxxxxxx
>> with 'subscribe' in the Subject field OR by logging into the Web
>> interface at //www.freelists.org/list/macvoiceover
>>
>
> Click on the link below to go to our homepage.
> http://www.icanworkthisthing.com
>
> Manage your subscription by using the web interface on the link below.
> //www.freelists.org/list/macvoiceover
>
> Users can subscribe to this list by sending email to
> macvoiceover-request@xxxxxxxxxxxxx
> with 'subscribe' in the Subject field OR by logging into the Web
> interface at //www.freelists.org/list/macvoiceover
>
Other related posts:
