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?
Help me please

=1022+SUM(E39:BY39)


Gord Dibben MS Excel MVP

On Mon, 24 Jul 2006 20:39:01 -0700, tbarrows
<[email protected]> 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?
>Help me please

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
> <[email protected]> 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?
> >Help me please
>
>