Please do. I use Numbers, so it will be useful and helpful to me. 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:40 PM, Ian Edwards <ianedwards42@xxxxxxxxx> wrote: > Thanks for your patience John. If I figure anything about this out I'll let > the list know as general information. > > Cheers, > > Ian > > On 2012-06-26, at 3:34 PM, John Panarese wrote: > >> This, I'm not sure of. Logically speaking, it shouldn't make a >> difference. I don't know why it would. However, I have not messed around >> with ranges like that. >> >> >> 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:30 PM, Ian Edwards <ianedwards42@xxxxxxxxx> wrote: >> >>> You've got it just how I know it. >>> >>> I was trying to mimick what Voicover was saying with the whole imbeded >>> thing. >>> >>> Here's what I've found playing around. It looks like I'm fine doing a sum >>> for a column, but it's not letting me use a range in a row. sosum(B7:B9) >>> worked, but sum(C7:I7) didn't. Is this normal that you can only use a >>> column to get a range sum? Maybe there's a different way of entering it >>> when it's a row? >>> >>> Ian >>> >>> On 2012-06-26, at 3:26 PM, John Panarese wrote: >>> >>>> 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 >>>>> >>> >>>> >>>> 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 >