Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

# Excel formulas problem

### #1 blaise78 Posted 02 October 2006 - 09:05 AM

blaise78

Member

• Member
• 19 posts
Hi,
I'm trying to enter a formula into a cell on Excel, but it's stopping me after a certain number - is there a cap on how many cells you can ask it to pick up, or how many characters there are?
• 0

### #2 dsenette Posted 02 October 2006 - 09:41 AM

dsenette

Je suis Napoléon!

• 26,023 posts
a better description of the formula you're trying to construct would be a good place to start here...what are you trying to do? what does the current formula look like? what about the data in the workbook? etc...
• 0

### #3 blaise78 Posted 02 October 2006 - 09:53 AM

blaise78

Member

• Topic Starter
• Member
• 19 posts
I'm trying to write a forumla into a cell on a front sheet that will pick up figures from the corresponding cells in the backsheets to give a total. It's fine and works ok right up until I've entered 30 in and then when I try to add any more it tells me I've 'entered too many arguments for this function'.
The formula looks like this: =SUM('Atkins'!C7,'Harpers'!C7......)
• 0

### #4 boomercj Posted 02 October 2006 - 11:50 AM

boomercj

Member

• Member
• 122 posts
Suggestion - create a worksheet with a column with the totals from Atkins, Harpers etc. (each cell linked) and then link the total from that column to the front worksheet.

So you will have a sheet with a total for Atkins, a sheet with a total for Harper and all the rest. Then link each total to a seperate cell in the column described above (you can hide this sheet) then link that total to the front sheet.

Hope this makes sense.
• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users