Jump to content

Welcome to Geeks to Go - Register now for FREE

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
Photo

Excel formulas problem


  • Please log in to reply

#1
blaise78

blaise78

    Member

  • Member
  • PipPip
  • 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

Advertisements


#2
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
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

blaise78

    Member

  • Topic Starter
  • Member
  • PipPip
  • 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

boomercj

    Member

  • Member
  • PipPipPip
  • 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

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP