Need help on creating a formula in excel

1. Need help on creating a formula in excel

I have a starting balance of 1,022.00 for savings... each pay day I want to
add to that balance....I am trying to get a formula to work I want the sum to
appear in Cell C39 and every other column is unused, my deposits to savings
(example would appear in columns E39, G39,I39 and so...) the only thing that
appears when following foluma is entered is ... #VALUE!

=SUM(1022+(E39:BY39))

How is this formula incorrect?

2. Re: Need help on creating a formula in excel

=1022+SUM(E39:BY39)

Gord Dibben MS Excel MVP

On Mon, 24 Jul 2006 20:39:01 -0700, tbarrows
<tbarrows@discussions.microsoft.com> wrote:

>I have a starting balance of 1,022.00 for savings... each pay day I want to
>add to that balance....I am trying to get a formula to work I want the sum to
>appear in Cell C39 and every other column is unused, my deposits to savings
>(example would appear in columns E39, G39,I39 and so...) the only thing that
>appears when following foluma is entered is ... #VALUE!
>
>=SUM(1022+(E39:BY39))
>
>How is this formula incorrect?

3. Re: Need help on creating a formula in excel

Thank YOU!! I have been working on this silly thing for about the past 4-6
hrs... you don't know how many times, I have felt like screaming... thank you
for such a quick reply to my problem

Sincerely
tbarrows

"Gord Dibben" wrote:

> =1022+SUM(E39:BY39)
>
>
> Gord Dibben MS Excel MVP
>
> On Mon, 24 Jul 2006 20:39:01 -0700, tbarrows
> <tbarrows@discussions.microsoft.com> wrote:
>
> >I have a starting balance of 1,022.00 for savings... each pay day I want to
> >add to that balance....I am trying to get a formula to work I want the sum to
> >appear in Cell C39 and every other column is unused, my deposits to savings
> >(example would appear in columns E39, G39,I39 and so...) the only thing that
> >appears when following foluma is entered is ... #VALUE!
> >
> >=SUM(1022+(E39:BY39))
> >
> >How is this formula incorrect?

>
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1