Printable View
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 ??
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.
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 ?
bump. When i try to put the values in to relevant box it just gives me an error message.
check your pm's.