[blaise78]

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?

[Advertisements]

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...

[dsenette]

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...

[blaise78]

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......)

[boomercj]

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.