Anabolics
Search More Than 6,000,000 Posts
Results 1 to 5 of 5
  1. #1
    Chemical King's Avatar
    Chemical King is offline Anabolic Member
    Join Date
    Apr 2004
    Location
    Here there and everywhere
    Posts
    2,110

    Help with Excell

    Im busy compiling a database of the foods I eat the most and am using Microsift Excell. I have only just started but wanted it so that instead of writing things down I want to be able to just click on the option and for it to automaticaly tally up the calories, protein and fat levels. Anyone know about this ??

  2. #2
    max2extreme's Avatar
    max2extreme is offline Anabolic Member
    Join Date
    Aug 2004
    Posts
    2,982
    lets say you have an excel sheet like this:

    4 3 4 8
    3 5 3 2 (and so on)
    _ _ _ _


    And you wanted to add down for example where the underlines are. select that box, then click on Insert and Function. then you'll see a box, just click on "most recently used" and there should be SUM. Click on that. then another box will show up. it should have like A1:A3 What that means is its going to add the sums of box a1, a2, and a3...you can put a1:a30 in there and it'll add all boxes in column a from a1 to a30. Then whenever you change a value, it is automatically added.

  3. #3
    Chemical King's Avatar
    Chemical King is offline Anabolic Member
    Join Date
    Apr 2004
    Location
    Here there and everywhere
    Posts
    2,110
    I already have the names of the foods and the values, but there is a way i can have sort of boxes to check then itl add it for me that way ?

  4. #4
    Chemical King's Avatar
    Chemical King is offline Anabolic Member
    Join Date
    Apr 2004
    Location
    Here there and everywhere
    Posts
    2,110
    bump. When i try to put the values in to relevant box it just gives me an error message.

  5. #5
    max2extreme's Avatar
    max2extreme is offline Anabolic Member
    Join Date
    Aug 2004
    Posts
    2,982
    check your pm's.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •