Help with Excell

[Chemical King]

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

[max2extreme]

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.

[Chemical King]

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 ?

[Chemical King]

bump. When i try to put the values in to relevant box it just gives me an error message.

[max2extreme]

check your pm's.