Thread: Help with Excell
03-15-2005, 06:23 AM #1
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 ??
03-15-2005, 06:30 AM #2
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.
03-15-2005, 06:44 AM #3
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 ?
03-15-2005, 08:12 AM #4
bump. When i try to put the values in to relevant box it just gives me an error message.
03-15-2005, 08:43 AM #5
check your pm's.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)