LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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 :)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula Q scoobz Excel Worksheet Functions 8 July 17th 06 07:19 AM
Advice on Creating an Excel Formula or Macro - PLEASE HELP!!!! So Tru Geo Excel Worksheet Functions 1 June 27th 06 07:15 PM
Trouble writing an excel formula. hbb2699 Excel Worksheet Functions 3 June 8th 06 06:36 PM
converting formula from lotus.123 to excel zaharah Excel Worksheet Functions 2 July 27th 05 03:04 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM


All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"