[macvoiceover] Re: Entering formulas in Numbers
- From: Ian Edwards <ianedwards42@xxxxxxxxx>
- To: macvoiceover@xxxxxxxxxxxxx
- Date: Tue, 26 Jun 2012 20:10:01 -0600
Ok here's what's happening.
It's a time tracking sheet, so there are 7 columns.
I'm in row 2, the 7 cells I want to sum start in columns C through I.
Cell B 2 is the location of my formula.
If I put in a formula ofsum(F2:I2) I get the last 4 numbers added fine.
If I add in cell E2, changing the formula to sum(E2:I2) the number doesn't
change.
Likewise if I add in C2 or D2.
Here's one thing I just noticed. I put the dates in above the 7 cells to be
summed. The first 3 dates, above the cells not playing nice, are text strings,
the last 4 are numeric representations of the dates. Is it possible that this
could effect the numbers in the cells below, telling the spreadsheet that they
aren't really numbers and don't count?
Ok, I just took a moment before I hit send and tried a fresh sheet. It summed
the row for me just fine when I didn't put anything in the row above, so I'm
going to assume that was the issue. Now I'll have to figure out how to make
that not happen. Excel scores a point here, when you put in a number in the old
behemoth, it darn well knows it's a number unless you tell it differently.
Next I'll try creating a sheet in Excel and importing it to Numbers just to see
what happens. That will have to wait til tomorrow, as I have dishes and
vacuuming to do.
Cheers,
Ian
On 2012-06-26, at 7:37 PM, Russell Solowoniuk wrote:
> Hi Ian,
>
> I just tried to sum a row in Numbers and it worked as expected. Are you
> pressing the enter key after entering the formula?
>
> Thanks
>
> Russell
> On 2012-06-26, at 4:10 PM, Ian Edwards wrote:
>
>> Ricardo,
>>
>> Do youhave experience entering a range formula based only on a row, like for
>> example c7:i7?
>>
>> For some reason column ranges are going fine, but when I enter in a row
>> range, it messes up the formula.
>>
>> Thoughts?
>>
>> Ian
>>
>> On 2012-06-26, at 4:06 PM, Ricardo Walker wrote:
>>
>>> Hi,
>>>
>>> not in my experience in numbers. The same formulas I learned for Excel,
>>> worked in Numbers.
>>>
>>> Ricardo Walker
>>> ricardo@xxxxxxxxxxxxxxxxxxx
>>> Twitter:@apple2thecore
>>> www.appletothecore.info
>>>
>>> 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
>
Other related posts:
