Excel formula help

[SoreArms]

I've been logging my macros on a notebook for a while now and I just relized, I have pocket PC, why am I not using that?

So I am trying to create an excel work sheet and use formulas to automaticaaly tell me my totals and percentages. Problem is, I'm a retard at using the formulas.

How do I enter a function to add evrything in the same row from, say, cell B2 down, automatically? The only formulas I've seen so far, make me have to specify the cell range, i want it to just add it all up from B2 down, etc...

I'll start there, once I figure that out I'll see how I can make it calculate percentages based on the value of two cells.

Thanks in advance.

 

[WODIN]

=sum(range)

 

[SoreArms]

=sum((range)

How do I make the range infinate in the same row, so that it includes anything I enter, and not just up to a ceratin cell?

 

[WODIN]

=sum (A:A) for instance will sum an entire column however you cannot have the formula in that column because it will create a circular reference. Just move the formula to the next column.

 

[SoreArms]

Sweet, thanks!

Now to figure out percentages.

 

[WODIN]

The formula would be for instance a2/a3. the / works as a divisor.

 

[SoreArms]

Got it, thanks.

I used
example:
=(((h3*4)/h1)*100) to get each macro's percentage (*9 for fat)

If there were only a way to create a database of foods that I could just click on to enter an item. Entering large amounts of data with the stylus is a p.i.t.a.

 

[tiger88]

lol this is really said on my part i should know that